Dynamic Ranges?

I am using a combo dropdown list. The list is linked to a name range.
I need the name range to change based on the value of another cell.

Example
If i put X in
A1 = x
Then
A2 = "NameRange1"

but...

If i put Y in
A1 = y
Then
A2 = "NameRange2"

Is this posible?

Thank you for your help,

Steve

Create a Range MyRange and make it equal the following formula

=if(Sheet1!$A$1="x",NameRange1,NameRange2)

Alok Joshi

"Smonczka" wrote:

> I am using a combo dropdown list. The list is linked to a name range.
> I need the name range to change based on the value of another cell.
>
> Example
> If i put X in
> A1 = x
> Then
> A2 = "NameRange1"
>
> but...
>
> If i put Y in
> A1 = y
> Then
> A2 = "NameRange2"
>
> Is this posible?
>
> Thank you for your help,
>
> Steve
>
>

Alok, thanks for your help. That worked perfectly.