Help - Xlookup to return email address based on name in Column A sheet 3

[pixal]

Hello,

I am trying to work out how to return the email address from the name found in sheet 3 column A if the name and email are found in sheet 2.

Name in column A is a formula to search if the name exists in sheet 1 and if does not exist then return name

=IF(COUNTIF(Sheet1!H:H, Sheet2!H2)=0, Sheet2!H2, "")

I now want to return the email address of this persons name from sheet 2 column I if the name in sheet 3 matches the name in sheet 2

Sheet 3 A2 if = Sheet 2 H then return sheet 2 I if that makes sense.

Help is appreaciated.

 

[pixal]

Opps worked it out, not Xlookup at all.

=INDEX(Sheet2!I:I, MATCH(Sheet3!A2, Sheet2!H:H, 0))