Excel Forum

Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table

See how to check if a record is in a table using VLOOKUP. See how to do this for a 2 column (field) table and a 4 column (field) table. See how to add a concatenated column and concatenate lookup_value in VLOOKUP function.
Match. Is record in table? Is item in list? Helper column to speed up calculations.

Got a Question? Ask it Here in the Forum.