| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Getting a named range from a cell value
I would like to get a name of a lookup table array from a cell value. A
formula in A1 would be =vlookup("G",A6,1) Where A6 contains "DR", the name of the table array. Can't get it to work. -- \\\|/// \\ ~ ~ // ( @ @ ) --oOOo-(_)-oOOo--- Charlie Woll |
|
#2
|
|||
|
|||
|
=vlookup("G",INDIRECT(A6),1)
-- HTH RP (remove nothere from the email address if mailing direct) "Charles Woll" wrote in message ... I would like to get a name of a lookup table array from a cell value. A formula in A1 would be =vlookup("G",A6,1) Where A6 contains "DR", the name of the table array. Can't get it to work. -- \\\|/// \\ ~ ~ // ( @ @ ) --oOOo-(_)-oOOo--- Charlie Woll |
|
#3
|
|||
|
|||
|
Bless you...
charlie "Bob Phillips" wrote in message ... =vlookup("G",INDIRECT(A6),1) -- HTH RP (remove nothere from the email address if mailing direct) "Charles Woll" wrote in message ... I would like to get a name of a lookup table array from a cell value. A formula in A1 would be =vlookup("G",A6,1) Where A6 contains "DR", the name of the table array. Can't get it to work. -- \\\|/// \\ ~ ~ // ( @ @ ) --oOOo-(_)-oOOo--- Charlie Woll |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Linear Mode
