• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP (I think)

mayhem

New Member
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
 

Attachments

  • ACECQA VLOOKUP List v2.xlsx
    551.7 KB · Views: 5
Look at the attached file where I joined your two tables in Power Query.
 

Attachments

  • ACECQA VLOOKUP List v2.xlsx
    770.6 KB · Views: 5
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
 
Back
Top