ExcelBanter - Getting a named range from a cell value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Getting a named range from a cell value (https://www.excelbanter.com/excel-worksheet-functions/15034-getting-named-range-cell-value.html)

Charles Woll

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

Bob Phillips

=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

Charles Woll

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

All times are GMT +1. The time now is 07:28 PM.