Indirect Help

[theta]

Hi, using INDIRECT but cannot get it to work in this particular instance

I have a static named range (just contains a single number) called KBMB.

Cell G7 contains "KB" and cell H7 contains "MB".

INDIRECT(G7&H7) does not provide me with any result, just get a #REF error

Formula evaluates to INDIRECT("KBMB")

?

 

[RoryA]

It's a limitation of INDIRECT - it will only work with a name that refers to a fixed cell address (it won't work with dynamic named ranges either).

 

[theta]

I see what you mean. INDIRECT is looking for a solid reference, but a defined name with no cell to anchor against will not be treated as a reference?