Vlookup Function

[Jac]

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!

 

[Pete_UK]

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

 

[Dave Peterson]

Debra Dalgleish has some very nice notes for =vlookup():
http://www.contextures.com/xlFunctions02.html (for =vlookup())

and if you want to return something that is to the left of the lookup column,
you can use =index(match()).

Debra also has notes:
http://www.contextures.com/xlFunctions03.html (for =index(match()))

 

[Jac]

Thanks, Pete!

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]

thanks, Dave! : )
& nice to receive some online resources from you...

 

[Pete_UK]

You're welcome.

Pete

Thanks, Pete!

 

[Mandy]

I tried to open this an it said page not found can you help

 

[Dave Peterson]

If you typed in that address, then try again. The site is there now and both
links work fine for me.