Vlookup Lookup Value Table Array Col Index Num Range Lookup. Range lookup here the range column of table 1 has variable data range. This is the value for which you are looking.
Lookup value lookup value is selected as c2 of the same table where array lookup is being applied. The first column in the cell range must contain the lookup value. You can use a named range or a table and you can use names in the argument instead of cell references.
Range lookup here the range column of table 1 has variable data range.
Lookup range the column range in the lookup sheets where to search for the lookup value. Value is either true or false. The first three arguments for vlookup are required. This is often referred to unofficially as the lookup table.
