You can use a named range or a table, and you can use names in the argument instead of cell references. The range of cells in which the VLOOKUP will search for the lookup_value and the return value.

Lookup_value can be a value or a reference to a cell. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument.įor example, if table-array spans cells B2:D7, then your lookup_value must be in column B. =VLOOKUP(A2,’Client Details’!A:F,3,FALSE) VLOOKUP (lookup_value, table_array, col_index_num, ) Use the VLOOKUP function to look up a value in a table.