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
Bookmarks