I am trying to figure out to make a simple lookup tool that will respond
with a specific answer based on the combination of two criteria.
Specifically, I have one drop-down with 52 items on it and another
drop-down with 200 items. What I want the sheet to do is this: When a
user selects one item from the first drop-down and another item from
the second drop-down a third cell will populate with a specific answer.
Like this

First drop-down: User selects the word "RED"

Second drop-down: User selects the number "15"

Based on these selections, the sheet should find the word "LOSE" and
populate a third cell with it.

Sorry for the long-winded question. Can anyone help guide me in the
right direction? Thanks.


--
bokonon
------------------------------------------------------------------------
bokonon's Profile: http://www.excelforum.com/member.php...o&userid=31107
View this thread: http://www.excelforum.com/showthread...hreadid=507740