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!