Hey! Here's my issue...

- I have created a few dynamic ranges named 'MyRange' and 'AnotherRange'
- I have also created a validation list dropdown with the values 'MyRange' and 'AnotherRange' to be selected.
- I select one of the ranges in the dropdown
- I now need to use the named range in a formula in an adjacent cell to do an index and match.
- this index and match needs to reference the text in the previous cell and translate it so the formula understands its a named range.

make sense?