Return the cell reference of the drop down list selection.

[YY san.]

Hi,
I try to look for a smilar question in the forum, but I couldnt find it.
Appreciate if some one could lend me a hand on this.
In SHEET1,I have the following and cell A(Mon~Fri) is defined as a name
range list, called FIVEDAYS.
A B
Mon Cool
Tue Warm
Wed Rain
Thu Snow
Fri Sunny

In SHEET 2, column F has a data validation list referring to FIVEDAYS. What
I want to show in SHEET 2, column G is the value of SHEET1 B values, which is
dependent on the what is selected in column F. What should be the formula in
column G?
The expected result should look like this:
SHEET 2
F G
Fri Sunny
Tue Warm
:
:
I know vlookup should work, but I believe there is a more clever way to do
this, using cell reference of the selected value in F.
Appreciate any help. Have a nice day!

 

[Ashish Mathur]

I know vlookup should work, but I believe there is a more clever way to do

this, using cell reference of the selected value in F.

You can use cell reference with the VLOOKUP()

in cell G2 of sheet 2, you can use the following VLOOKUP() formula

=VLOOKUP(F2,Sheet1!A1:B5,2,0)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com