=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