May 04 2022 09:43 AM
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
May 04 2022 09:57 AM
=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.