Col Index Number. First is column index of state in table is 11 and second is named range header works fine. The col index num is the column of data that contains the answer that you want.
Match index in vlookup function. Hence match will lookup for any value written in h3 in range b3 e3 and will return its index number. Column 1 student id number column 2 student names column 3 grades and you inputted a student id number and you want to retrieve the grade that was received for that person the col index num would be 3.
Copy the formula for remaining column names using ctrl d or dragging down from the right bottom edge the used cell.
The col index num is the column of data that contains the answer that you want. Here we have all the column index. Copy the formula for remaining column names using ctrl d or dragging down from the right bottom edge the used cell. 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.
