I have a table similar to the below:
Red Blue Green
Small A B C
Medium D E F
Large G H I
I want to be able to enter a colour and a size in separate cells, and
then in another cell have a formula which tells me what the result is
(e.g. if I entered 'Medium' and 'Blue' the result would be 'E').
I assume the answer lies in combining a VLOOKUP with a HLOOKUP, but I
can't work out how to do it. I guess I would have to change the
criteria to be in alphabetical order as well (e.g. Large, Medium, Small
and Blue, Green, Red) for it to work.
Hope someone can help!
Thanks
Catherine
--
CDM
------------------------------------------------------------------------
CDM's Profile:
http://www.excelforum.com/member.php...o&userid=32339
View this thread:
http://www.excelforum.com/showthread...hreadid=521007