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

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

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?


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

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

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

Debra Dalgleish Wrote:
You could use data validation to create the dropdown lists, as
described
he

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
------------------------------------------------------------------------
aposatsk's Profile: http://www.excelforum.com/member.php...o&userid=36709
View this thread: http://www.excelforum.com/showthread...hreadid=573157

Nevermind!!

Thank you!


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

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
he

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