Col Index Num In Vlookup. In a cell that corresponds to that matching value if it helps think of that third value col index num as your search result. 1 your data needs to be set up in a table in this example the table name is data1.
Vlookup a2 data1 column data1 location 0 there are a few conditions. Examples vlookup lookup value table array col index num range lookup what value are you. The last one is optional but defaults to true if you leave it out.
The formula you would enter is.
Examples vlookup lookup value table array col index num range lookup what value are you. The first three arguments for vlookup are required. The last one is optional but defaults to true if you leave it out. Vlookup a2 data1 column data1 location 0 there are a few conditions.
