Excel Forum
Similar Content
Determine if Cells Contain a Specific Value in Excel
Tutorial: Find if a cell or range of cells contains a specific value in Excel. This method can be us...
Formula to Count Occurrences of a Word in a Cell or Range in Excel
Tutorial: Formula to count how many times a word appears in a single cell or an entire range in Exce...
Vlookup to Return the Min, Max, or Average Value in Excel
Tutorial: Perform a Vlookup that returns the highest value, lowest value, or average value from a d...

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.