Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation List
Hi,
I have a dropdown from a validation list. I want to reference the cell that the list is pointing to. Ex. my list where the dropdown is located is E71, the list is located at AC69 and is 23 rows. When an item is selected from the list, I want to reference the cell in the list (AC69-AC91) not E71. -- TIA AFJr |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data Validation - List - keeping the format of the list - shading | Excel Discussion (Misc queries) | |||
Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel |