On Sep 4, 4:03*pm, Mary Ann <Mary
wrote:


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

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

Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
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:

--

Dave Peterson