Return range name from concatenated strings

As I mentioned, INDIRECT will only work with a named range (your example 1 is a named constant - a string - not an actual range). It will also only work with static named ranges, not dynamic, which is why example 2 fails. If you need to work with a dynamic range, you can use EVALUATE but that can only be used in a defined name, not in a worksheet cell directly.