Col Index Num In Vlookup. Examples vlookup lookup value table array col index num range lookup what value are you. Hence match will lookup for any value written in h3 in range b3 e3 and will return its index number.
The above vlookup function returns the price for cornflakes which is 3 50. The vlookup formula will finally have it s col index num. The first three arguments for vlookup are required.
1 your data needs to be set up in a table in this example the table name is data1.
The last one is optional but defaults to true if you leave it out. Vlookup g4 b4 e16 2 0 as we know the match function returns the index number of a given value in the supplied one dimensional range. 1 your data needs to be set up in a table in this example the table name is data1. Vlookup a2 data1 column data1 location 0 there are a few conditions.
