VLOOKUP (I think)

[mayhem]

Help, it's been years since I used Excel and I need to update the email addresses (Column G) in the 2nd tab (22-23) with email addresses from the 1st tab (21-22) where the conditions of Columns A match (Centre Name). If it's possible to populate based on Columns A & C matching would help even more. Please advise.

Thank you

 

[AlanSidman]

Look at the attached file where I joined your two tables in Power Query.

 

[pecoflyer]

A formula solution attached

 

[bosco_yip]

Or,

In "Sheet22-23 G2", formula copied down :

=IFERROR(LOOKUP(1,0/('21-22'!$A$2:$A$3685='22-23'!$A2)/('21-22'!$C$2:$C$3685='22-23'!$C2),'21-22'!$G$2:$G$3685),"")

Regards

 

[mayhem]

Thank you @ AlanSidman, @pecoflyer, and @bosco_yip, you've all provided me with different solutions expanding my options in the future.

Wishing you a beautiful week ahead,
mayhem