That is correct. If it isn't, use a combination of index and match

=Index(columnA, match(value,columnB,0),1)

as an example.

--
Regards,
Tom Ogilvy


"Marc" wrote in message
hlink.net...
Dave if I'm not mistaken VLOOKUP only works if your "standard" is in the
far
left column.

Marc

"davesexcel"
wrote
in message ...

check out VLOOKUP, there are lots of posts of this in your forum and in
the many excel websites such as he

http://www.contextures.com/xlFunctions02.html


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=528940