refer to static list of cell addresses with INDIRECT

Hi all,

How can I refer to a static list of cell addresses with INDIRECT if I have below names:

e.g.

FY16_CRSPSU_SLS_UNT ($H$391:$S$391)
FY16_CRSPSU_SLS_CST ($H$392:$S$392)


my formula currently looks like this:

Please Login or Register  to view this content.

where Selected_ST_Metric is either "CST" or "UNT". I'm getting a #REF error. Though, this usually works just fine with named ranges, but does not seem to work with a static range...

Because your range refers to a sheet, so it's not a static cell address, mine does not!

Please Login or Register  to view this content.

vs.

Please Login or Register  to view this content.

The sheet changes for me, that's why I cannot use your example!

My formula is actually also checking the sheet name (region). So it looks something like this:

Please Login or Register  to view this content.

but as soon as you 'break' the static named range. I get an #REF error:

Please Login or Register  to view this content.