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 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
###---------###

[Marcelo]

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
>
>

[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 wrote:
> 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
> ###---------###
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

[aposatsk]

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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

But the value "B3" in the vlookup formula has to change with respect to the value chosen in the drop down menu. How could I make this value 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

aposatsk wrote:
> Debra Dalgleish Wrote:
>
>>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.
>>
>>
>>--
>>Debra Dalgleish
>>Contextures
>>http://www.contextures.com/tiptech.html
>
>
> But the value "B3" in the vlookup formula has to change with respect to
> the value chosen in the drop down menu. How could I make this value
> comply with the drop-down menu choice?
>
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html