VLOOKUP or XLOOKUP

[amolitor]

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

[#2]

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