Hi,
I think you're going to have a problem with trying to do this this way.
The trouble starts with the way that Vlookup and Hlookup work: They need
the data to be sorted so that each value (peanut or coconut) has a
different reference (you have three fruit all represented by the same
reference - this is why you always get peanuts as the answer. I'm not
sure yet what the answer is, but it probably does not involve the
vlookup function

Not much help, but at least you know what not to use

Cheers


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=560159