Col Index Number Vlookup. The first three arguments for vlookup are required. Read its definition at the bottom of the formula palette.
The price is in the second column of the table. Nothing to do with where it is in excel it s the column number in the table. Hence match will lookup for any value written in h3 in range b3 e3 and will return its index number.
If it helps think of that third value col index num as your search result.
You can use the column function to quickly determine the col index num of the vlookup formula without having to count columns. Hence match will lookup for any value written in h3 in range b3 e3 and will return its index number. Read its definition at the bottom of the formula palette. You can use the column function to quickly determine the col index num of the vlookup formula without having to count columns.
