Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the cell reference of the drop down list selection.
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return the cell reference of the drop down list selection.
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 "YY san." wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list - need to reference and populate another cell with | Excel Discussion (Misc queries) | |||
drop down list that changes cell color upon selection | Excel Discussion (Misc queries) | |||
Linking a selection in a drop down list to a calc in another cell | Excel Worksheet Functions | |||
Selection of Drop down list that allows you to go to a particular cell | Excel Worksheet Functions | |||
Place a set value in a cell from a drop down list name reference | Excel Worksheet Functions |