Using VLookup, how can I retireve the related columns.

[sbitaxi]

Mary Ann, you've provided very little information. Are you trying to
use VLookup programmatically or in a formula? The Excel Help
documentation on VLookup is pretty good if using it in a formula.

Regards,

Steven

 

[Dave Peterson]

You may want to use =index(Match()).

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) here:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble



Mary Ann wrote: