Table Array Lookup Vlookup. And table array is the combination of two or more than two tables which has data and values linked and related to one another. The table array argument is always the second argument in a vlookup or hlookup function the first is the value you re trying to find and the functions won t work without it.
Syntax of vlookup function vlookup lookup value table array col index num range lookup the parameters of the vlookup function are. Figure 1 setting up the data. Your first argument the value you want to find can be a specific value such as 41 or smith or it be a cell reference such as f2.
Vlookup c7 j7 l20 3 i want the table array to remain constant to j6 l19 the lookup value should change ie c6 to c7 but i can t seem.
In the example shown the formula in cell e4 is. Lookup value the value that we want to search and find in the table array. Mention the column number as 3 to for dept. Figure 1 setting up the data.
