Question about range in validation list

H

Hank

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.
 
E

Elkar

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
 
Top