Create an expression to access a range name

[graurotbart]

I’m trying to access a range name using an expression. I have two cells, that when concatenated, equal a named range. I’m trying to simply use CONCAT("=",D4,C5) but it just returns the ‘text’ and not an expression. Cells D4 and C5 hold the text JAN and INCOME respectively.

It returns =JANINCOME. This is what I want, but I need it to evaluate as an expression rather than text.

[karolus]

Try:

=INDIRECT(D4&C5)

[graurotbart]

Thank you karolus - worked like a champ