Sunday, 25 August 2013

Excel reference named range with text and formula

Excel reference named range with text and formula

Is it possible to refer to a named range by combining text with a formula?
Say I get a name for a range via INDEX which returns a text but I also
want to add something after the text like so:
RANGE & "Whatever comes after"
I have several named ranges so in order to dynamically refer to those
ranges I need to add something after that RANGE text. Excel however gives
an error.
In a nutshell
Named ranges:
RANGE1 RANGE2 RANGE3 etc.
What I want is say with a count formula:
=COUNTIF(RANGE & "whatever comes after",1)
If I try to do this then Excel gives an error so is what I'm trying to do
even possible?

No comments:

Post a Comment