Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about range in validation list
Here is my problems,
I have a range named "A" I have a value equal to "A" How can I have validation list use value "A" and refer to the range name "A" Thanks alot. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about range in validation list
I'm not sure I understand what you're trying to do, but perhaps the INDIRECT
function might be what you're looking for. Let's say your value of "A" is stored in cell A1. To use this value to determine a validation list, you'd use the formula: =INDIRECT(A1) If not, please post back with more details. HTH Elkar "Hank" wrote: Here is my problems, I have a range named "A" I have a value equal to "A" How can I have validation list use value "A" and refer to the range name "A" Thanks alot. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about range in validation list
This is exactly what I expect, thanks Elkar. My problem solved.
Hank "Elkar" wrote: I'm not sure I understand what you're trying to do, but perhaps the INDIRECT function might be what you're looking for. Let's say your value of "A" is stored in cell A1. To use this value to determine a validation list, you'd use the formula: =INDIRECT(A1) If not, please post back with more details. HTH Elkar "Hank" wrote: Here is my problems, I have a range named "A" I have a value equal to "A" How can I have validation list use value "A" and refer to the range name "A" Thanks alot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validation drop down list question | Excel Worksheet Functions | |||
Validation List/Formula Question | Excel Discussion (Misc queries) | |||
Data Validation List Question | Excel Discussion (Misc queries) | |||
Data Validation-List..Question? | Excel Discussion (Misc queries) | |||
Edit validation list range | Excel Discussion (Misc queries) |