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