| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using a "variable" in range names
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not delete worksheets from names in a range | Excel Discussion (Misc queries) | |||
| how do i create range names ? | Excel Worksheet Functions | |||
| Range Names | Excel Worksheet Functions | |||
| Excel Range Names | Excel Discussion (Misc queries) | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Threaded Mode
