Hi,

why not use a Pivot Table? it certainly will help you a lot
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"aposatsk" escreveu:


My book contains 2 sheets. The second sheet is the following format:

A---------B
abc-----###
def-----###

And the list continues with text in column A and values in Column B for
many, many values.

In the first sheet, I want to have 2 drop down menus. They would be
side by side for the sake of comparison. In each menu, one is able to
see all of the different texts that are in column A in sheet 2.
Therefore, one may choose 'abc' in one drop down menu, and 'def' in the
other. Then, I would like the respective value from column B (sheet 2)
to display below the drop down menu.

So in Sheet 1, if I chose 'abc' in one menu, and 'def' in the other, i
would get something like this in sheet 1:

ABC----------DEF
###---------###


--
aposatsk
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=573157