Hi folks. I have done this before and should know it. It is a simple
thing, I just cannot recall at this time.

I want to enter a range name in a cell so the value of that named range
shows up (single cell named ranges) i.e. =RangeName

This works. I now want to dynamically construct that call using other
single cell range names, so I use concatenate to "assemble" the values of
those named ranges together into one text string that also happens to
match a named range single cell value.

All I see in the cell is the concatenated value, not the resolved range
name cell value

I use a Y/N cell to turn it on, so I use:

=IF(B13="Y",Concatenate(Rngname1,rngname2,rangname 3,"text"))

All I get is the concatenated text,and I want the constructed range
name to resolve. I have done this before and even been hand held through
it, but I cannot remember it for the life of me. I think I alter the
result with "TEXT()" or something similarly easy. I could put that text
in another cell, and call it directly, which does not need additional
conversion.