Xlookup - Not returning expected result

[psycoperl]

Good Day -
I am working on a workbook that has two sheets
FIND_PLC and UGRADADID20220608

On FIND_PLC in Column A I have a list of user ID# (they are text strings in the format of 00000000). In Column S of this sheet, I want to get their EMAIL address which is listed in the Column E of UGRADADID.

In UGRADADID the UserID#s are in Column A.

I am using the formula =XLOOKUP($A2,UGRADADID!$A$2:$A$23104,UGRADADID!$E$2:$E$23104)

However, I am getting #N/A instead of the expected value.

If I copy the USERID# and search it (CTRL+F) it exists in the UGRADADID sheet.

Guidance is welcome

 

[Jimmypop]

This should work dependant on the USERID# also being in UGRADID sheet in range A1 to A9

=XLOOKUP(A1:A9,UGRADADID20220608!A1:A9,UGRADADID20220608!E1:E9,"",0)