look here for a solution by the late Frank Kabel
http://tinyurl.com/aszhq

--
Don Guillett
SalesAid Software

"GWHITE1" wrote in
message ...

I have a worksheet that I am trying to use Vlookup on to return specific
info, however vlookup will stop at the first reference it sees and
return that value back instead of the next one which I need. I am sure
there is a way of telling it to look at the 2nd or third item in the
reference array to return the specific info I need. What I am not sure
of is how to tell it to do that.

help....


--
GWHITE1
------------------------------------------------------------------------
GWHITE1's Profile:
http://www.excelforum.com/member.php...o&userid=29969
View this thread: http://www.excelforum.com/showthread...hreadid=496635