formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1492965%22%20slang%3D%22en-US%22%3Eformula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492965%22%20slang%3D%22en-US%22%3E%3CP%3EWhich%20formula%20can%20I%20use%20to%20find%20the%20Employee%20Name%20in%20Column%20H%20from%20the%20code%20in%20Column%20G%20in%20the%20Employee%20Table.%26nbsp%3B%20My%20Office%20365%20does%20not%20have%20the%20formula%20function%20xlookup.%26nbsp%3B%20Please%20see%20the%20attached%20in%20the%20Functions%20Tab.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1492965%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493275%22%20slang%3D%22en-US%22%3ERe%3A%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493275%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F710780%22%20target%3D%22_blank%22%3E%40mvanoord%3C%2FA%3E%26nbsp%3B%20use%20vlookup%20instead%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493291%22%20slang%3D%22en-US%22%3ERe%3A%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493291%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20watch%20the%20short%20video%20below%20of%20both%20VLOOKUP%20and%20XLOOKUP%20yo%20guide%20you%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493529%22%20slang%3D%22en-US%22%3ERe%3A%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493529%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F710780%22%20target%3D%22_blank%22%3E%40mvanoord%3C%2FA%3E%26nbsp%3BYour%20example%20clearly%20suggests%20to%20use%20XLOOKUP.%20But%20since%20your%20Excel%20doesn't%20support%20that%20function%20yet%2C%20you%20need%20to%20use%20a%20combination%20of%20INDEX%20and%20MATCH%20in%20H2%20and%20copy%20it%20down.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DINDEX(A%3AA%2CMATCH(G2%2CC%3AC%2C0))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20order%20of%20the%20columns%20A%3AD%20isn't%20suitable%20for%20using%20VLOOKUP%20straight%20away.%20You%20need%20to%20move%20the%20%22ID%23%22%20column%20towards%20the%20left%20side%20of%20your%20table%2C%20so%20that%20it%20becomes%20column%20A.%20Then%20you%20can%20use%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DVLOOKUP(G2%2CA%3AD%2C2%2CFALSE)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Ein%20H2%20in%20stead.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20XLOOKUP%20becomes%20available%20in%20your%20Windows365%20channel%2C%20this%20would%20be%20how%20to%20use%20it%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DXLOOKUP(G2%2CC%3AC%2CA%3AA%2C%22%22%2C0%2C1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.  

3 Replies

@mvanoord  use vlookup instead

Hello,

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

@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)