Col Index Number Vlookup. You can use the column function to quickly determine the col index num of the vlookup formula without having to count columns. The range lookup argument is critical.
Read its definition at the bottom of the formula palette. Nothing to do with where it is in excel it s the column number in the table. The last one is optional but defaults to true if you leave it out.
If it helps think of that third value col index num as your search result.
The formula you would enter is. 1 your data needs to be set up in a table in this example the table name is data1. If it helps think of that third value col index num as your search result. Vlookup a2 data1 column data1 location 0 there are a few conditions.
