using a "variable" in range names
I got it to work by using INDIRECT("rn"&A1&"mw")
I'm not sure what teh "allow labels" does. But it is checked in my excel.
"paul" wrote in message
...
i have a similar quandary,would it work if you allow labels in
formulas???(tools options,calculation,tick allow labels in formulas)
--
paul
remove nospam for email addy!
"Bob Phillips" wrote:
Can't see it without INDIRECT.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
Can you us a "variable" in a range name without having to INDIRECT() to
another cell?
-facts-
A1 has a number in it
rn1mw, rn2mw, rn3mw, rn4mw, rn5mw are valid ranges
-problem-
I want to use a vlookup to one of the above ranges. Something like:
VLOOKUP("bongo", CONCATENATE("rn",A1,"mw"), 0)
or
VLOOKUP("bongo", "rn"&A1&"mw", 0)
of course those formulas do not work.....
thanks in advance
|