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.

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.

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.