formula

[mvanoord]

Which formula can I use to find the Employee Name in Column H from the code in Column G in the Employee Table.  My Office 365 does not have the formula function xlookup.  Please see the attached in the Functions Tab.  

[#2]

@mvanoord  use vlookup instead

[#3]

Hello,

You can watch the short video below of both VLOOKUP and XLOOKUP yo guide you

[#4]

@mvanoord Your example clearly suggests to use XLOOKUP. But since your Excel doesn't support that function yet, you need to use a combination of INDEX and MATCH in H2 and copy it down.

=INDEX(A:A,MATCH(G2,C:C,0))

The order of the columns A:D isn't suitable for using VLOOKUP straight away. You need to move the "ID#" column towards the left side of your table, so that it becomes column A. Then you can use

=VLOOKUP(G2,A:D,2,FALSE)

in H2 in stead.

When XLOOKUP becomes available in your Windows365 channel, this would be how to use it

=XLOOKUP(G2,C:C,A:A,"",0,1)