Getting a named range from a cell value

C

Charles Woll

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
 
B

Bob Phillips

=vlookup("G",INDIRECT(A6),1)


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top