Vlookup Function
You're welcome.
Pete
Jac wrote:
Thanks, Pete!
"Pete_UK" wrote:
If your lookup values are not in the leftmost column of the lookup
table, then you can't use VLOOOKUP - however, a combination of INDEX
and MATCH can be used in this situation
Hope this helps.
Pete
Jac wrote:
hi,
Vlookup function needs a parameter named Lookup_value & according to the
description in Function Argument Wizard, it is the value to be found in the
1st column of the table (leftmost column of a table).
The table mentioned above, is it the newly created table or Table_array?
Another thing is this convention a must?
What about the data which are going to look up for are not in the leftmost
column?
Thanks!
|