What Is Col Index Number In Excel. The match function logic is the same as for the regular cell ranges. The lookup value is always in the left most column of the table array column 1 regardless of where in the worksheet the table is located.
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. In a cell that corresponds to that matching value if it helps think of that third value col index num as your search result. Examples vlookup lookup value table array col index num range lookup what value are you.
When you use the index or vlookup functions you need to specify which column to return values from in relative rather than absolute fashion.
The lookup value is always in the left most column of the table array column 1 regardless of where in the worksheet the table is located. If your table is set up as. Examples vlookup lookup value table array col index num range lookup what value are you. The formula you would enter is.
