Col Index Number Vlookup. The col index num column index number is the relative column number in the list. The formula you would enter is.
If it helps think of that third value col index num as your search result. The col index num column index number is the relative column number in the list. Read its definition at the bottom of the formula palette.
Hence match will lookup for any value written in h3 in range b3 e3 and will return its index number.
The vlookup formula will finally have it s col index num. You can use the column function to quickly determine the col index num of the vlookup formula without having to count columns. Read its definition at the bottom of the formula palette. The vlookup formula will finally have it s col index num.
