I need to combine the contents of two cells and have the result return the value of a Named Range(single cell). I am trying to use “&”, to no avail. Here is what I have tried so far:
Cell E4 = “e”
Named Range “ePercRange” = 100
Cell F4 =E4&"PercRange"
Cell F$ returns = “ePercRange” instead of the value of named range ePercRange
Is there a way to make the combined text return the value of a Name?
Thanks
Robert
Bookmarks