Col Index Num. The col index num is set to 2 to denote that the value returned should be taken from column 2 of the table array. Col index num is a required parameter in vlookup function in excel.
If we remove or add a column before or after the 3rd column the 3rd column will not refer to the intended column anymore. If your table is set up as. If true or omitted vlookup returns either an exact or approximate match.
You can use the column function to quickly determine the col index num of the vlookup formula without having to count columns.
You can use the column function to quickly determine the col index num of the vlookup formula without having to count columns. First is column index of state in table is 11 and second is named range header works fine. The above vlookup function returns the price for cornflakes which is 3 50. Go to another location find a match for my value and then show me the words or numbers that reside in a cell that corresponds to that matching value if it helps think of that third value col index num as your search result.
