VLOOKUP or XLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-3306577%22%20slang%3D%22en-US%22%3EVLOOKUP%20or%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3306577%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20match%20data%20from%202%20different%20sheets%2C%20on%20sheet%201%20(CARDS)%20i%20am%20trying%20to%20place%20data%20in%202%20columns%20Fname%20and%20Lname%20(Columns%20T%20and%20U%20on%20the%20CARDS%20sheet%20and%20Columns%20C%20and%20D%20on%20the%20NAMES%20sheet%2C%20respectively)%26nbsp%3B%20that%20matches%20with%20data%20in%20sheet%203%20(NAMES)%26nbsp%3B%20on%20the%20same%20column%2C%20the%20identifier%20that%20matches%20on%20both%20sheets%20is%20NAMEID(Column%20B%20on%20the%20CARDS%20sheet)%20and%20ID(Column%20A%20on%20the%20NAMES%20Sheet)%20this%20is%20for%20approximately%201500%20rows%2C%20the%20examples%20of%20the%20lookup%20formulas%20are%20not%20easy%20for%20me%20to%20follow%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3306577%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3308018%22%20slang%3D%22en-US%22%3ERe%3A%20VLOOKUP%20or%20XLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3308018%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381018%22%20target%3D%22_blank%22%3E%40amolitor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DVLOOKUP(%24B2%2CNAMES!%24A%242%3A%24D%2428%2CCOLUMN(NAMES!C%3AC)%2CFALSE)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EMaybe%20with%20this%20formula.%20Enter%20the%20formula%20with%20ctrl%2Bshift%2Benter%20if%20you%20don't%20work%20with%20Office365%20or%202021.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20alternative%20could%20be%20INDEX%20and%20MATCH.%20If%20you%20work%20with%20Office365%20or%202021%20you%20can%20apply%20XLOOKUP%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to match data from 2 different sheets, on sheet 1 (CARDS) i am trying to place data in 2 columns Fname and Lname (Columns T and U on the CARDS sheet and Columns C and D on the NAMES sheet, respectively)  that matches with data in sheet 3 (NAMES)  on the same column, the identifier that matches on both sheets is NAMEID(Column B on the CARDS sheet) and ID(Column A on the NAMES Sheet) this is for approximately 1500 rows, the examples of the lookup formulas are not easy for me to follow

1 Reply

@amolitor 

=VLOOKUP($B2,NAMES!$A$2:$D$28,COLUMN(NAMES!C:C),FALSE)

Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.

 

An alternative could be INDEX and MATCH. If you work with Office365 or 2021 you can apply XLOOKUP as well.