Col Index Number Excel Vlookup. Below is the generic formula. Hence match will lookup for any value written in h3 in range b3 e3 and will return its index number.
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. Then we will proceed to further step how to lookup values in tables using the match function.
Below is the generic formula.
1 your data needs to be set up in a table in this example the table name is data1. 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. Hence match will lookup for any value written in h3 in range b3 e3 and will return its index number. Here we need to get index number of the column name.
