Col Index Num Excel Vlookup. Vlookup a2 data1 column data1 location 0 there are a few conditions. Here we need to get index number of the column name.
You can use the column function to quickly determine the col index num of the vlookup formula without having to count columns. The formula you would enter is. Below is the generic formula.
The above vlookup function returns the price for cornflakes which is 3 50.
The vlookup formula will finally have it s col index num. Then we will proceed to further step how to lookup values in tables using the match function. The vlookup formula will finally have it s col index num. 1 your data needs to be set up in a table in this example the table name is data1.
