Vlookup using one of two criteria

[Zumas36]

I have a sheet(1) with 3 columns, (ID number, employee number and employee name). On a separate sheet(2), I want to type out either the ID number or the employee number in column 1 and column two will yield the result of the employee name. I want to be able to do this for sheet(2) for an entire list of people who will fill in a register with either their ID or employee number to tracker attendance.

 

[SanjayGMusafir]

I have a sheet(1) with 3 columns, (ID number, employee number and employee name). On a separate sheet(2), I want to type out either the ID number or the employee number in column 1 and column two will yield the result of the employee name. I want to be able to do this for sheet(2) for an entire list of people who will fill in a register with either their ID or employee number to tracker attendance.

Please update your current version of excel and platform to give you an optimal solution.

You can use the link below in my signatures to update your account details.

 

[Dspace]

Try this...=XLOOKUP(E2,A:A,C:C,XLOOKUP(E2,B:B,C:C))

Let me know if this works. If I enter 1 or 2 its resulting in "me". same for 2 & 4 for You etc. The second Xlookup only kicks in if the first Xlookup fails.

 

[Zumas36]

Try this...=XLOOKUP(E2,A:A,C:C,XLOOKUP(E2,B:B,C:C))

Let me know if this works. If I enter 1 or 2 its resulting in "me". same for 2 & 4 for You etc. The second Xlookup only kicks in if the first Xlookup fails.
View attachment 105512

Wow this works brilliantly, thank you so so much. I highly appreciate it.