Hello,
Please help.
I have been searching all over and found some VBA examples, but I am not good with VBA.
I would prefer formula solution.
Example:
I have two named ranges on Sheet 2 called "Range1" & "Range2".
Sheet 1 Column A are the trigger cells.
If A1 has a value of 1 I need the named range "Range1" to automatically be pasted into cell B1.
Conversely, if A1 has a value of 2 I need the named range "Range2" to automatically be pasted into cell B1.
Thank you,
B
Please help.
I have been searching all over and found some VBA examples, but I am not good with VBA.
I would prefer formula solution.
Example:
I have two named ranges on Sheet 2 called "Range1" & "Range2".
Sheet 1 Column A are the trigger cells.
If A1 has a value of 1 I need the named range "Range1" to automatically be pasted into cell B1.
Conversely, if A1 has a value of 2 I need the named range "Range2" to automatically be pasted into cell B1.
Thank you,
B