Drop-Down Menus

[aposatsk]

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 fo
many, many values.

In the first sheet, I want to have 2 drop down menus. They would b
side by side for the sake of comparison. In each menu, one is able t
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 th
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,
would get something like this in sheet 1:

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

 

[Guest]

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:

 

[aposatsk]

Thanks, but do you mind giving me some hints on how I would set up a
Comparison-like format using Pivot Tables? Perhaps a tutorial?

 

[Debra Dalgleish]

You could use data validation to create the dropdown lists, as described
here:

http://www.contextures.com/xlDataVal01.html

In the cells below, use a VLookup formula to return the value for the
selected item. For example, if the first dropdown is in cell B3, enter
the following formula in cell B4:

=VLOOKUP(B3,ValuesTable,2,FALSE)

where ValuesTable is the range on the second sheet that contains all the
text and values.

 

[aposatsk]

You could use data validation to create the dropdown lists, a
described
here:

http://www.contextures.com/xlDataVal01.html

In the cells below, use a VLookup formula to return the value for the
selected item. For example, if the first dropdown is in cell B3, enter
the following formula in cell B4:

=VLOOKUP(B3,VALUESTABLE,2,FALSE

where ValuesTable is the range on the second sheet that contains al
the
text and values.

But the value "B3" in the vlookup formula has to change with respect t
the value chosen in the drop down menu. How could I make this valu
comply with the drop-down menu choice

 

[aposatsk]

Nevermind!!

Thank you

 

[Debra Dalgleish]

Did you try the formula?
B3 is a reference to the cell, so the formula result in cell B4 should
change when you select a different value from the dropdown in B3