Col Index Num Excel Vlookup. The vlookup formula will finally have it s col index num. The formula you would enter is.
If you lock the lookup table excel always refers back to cells a2 through 38 no matter where you copy the vlookup formula. Then we will proceed to further step how to lookup values in tables using the match function. The formula you would enter is.
For example column in the pages worksheet contains the page names that you want to find.
You can use the column function to quickly determine the col index num of the vlookup formula without having to count columns. Hence match will lookup for any value written in h3 in range b3 e3 and will return its index number. The formula could also use a cell reference and a range reference. The vlookup formula will finally have it s col index num.
