Help using named range with index function

[mpjennings25]

I have an index function:

Please Login or Register  to view this content.

Cell B4 allows you to select a value from a list, and each value is the name of a named cell range.

For example, if I set B4 to equal "_CGF01", I want the INDEX function to reference the first row and first column in range _CGF01. However, this formula just returns the value _CGF01 instead of using the lookup within that range. How can I fix this?

Thanks!

[XOR LX]

Hi,

Try:

=INDEX(INDIRECT($B$4),1,1)

Regards