| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get the cell reference of the value selected from name list
Hi,
I have a name list range called Workdays in Sheet2 consists of name range values A1~A5 = Monday ~ Friday. In Sheet1, colum A, I have a data validation referring to this list. If in cell A1, Friday is selected. I want to show "A5" in B2 of Sheet1. Can anyone help? Thanks so much for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to use a list box or reference a cell | Excel Worksheet Functions | |||
| Autofill cell/sets of cells based upon value selected from a list. | Excel Discussion (Misc queries) | |||
| A validated List which link to selected cells according to what is selected on the list | Excel Worksheet Functions | |||
| A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
| Display the cell reference of the cell that is currently selected. | Excel Worksheet Functions | |||
![YY san.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
