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