Vlookup Lookup Value Table Array Col Index Num Range Lookup. Table array table array is table 2 which is shown in the above screenshot. Table array the data range in the lookup sheets.
Col index num it is selected as 2 as the second column of table 2. You can use a named range or a table and you can use names in the argument instead of cell references. Syntax of vlookup function.
Vlookup function looks up the lookup value in the table array in first column of a table and returns the corresponding value from the col index num.
Range lookup here the range column of table 1 has variable data range. The last one is optional but defaults to true if you leave it out. Range lookup here the range column of table 1 has variable data range. For the formula to work correctly please bear in mind the following caveats.
