| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help in refering to a range named in a cell
Hi to all,
I am trying to use a regular vlookup formula in which I could refer to a range not by specifying a name but by refering to a cell in which the range is named. example: =vlookup(a1;b1;2;false) where; b1 is the name of the range I am referring to. Is this possible? thanks for your help. jf |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
help in refering to a range named in a cell
=vlookup(a1;Indirect(b1);2;false)
-- Regards, Tom Ogilvy "jf" wrote in message om... Hi to all, I am trying to use a regular vlookup formula in which I could refer to a range not by specifying a name but by refering to a cell in which the range is named. example: =vlookup(a1;b1;2;false) where; b1 is the name of the range I am referring to. Is this possible? thanks for your help. jf |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you name a worksheet by refering to a cell reference or range | Excel Discussion (Misc queries) | |||
| Refering to a named range in a chart: 2007 | Excel Worksheet Functions | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| refering to a range with a variable | Excel Programming | |||
Linear Mode
