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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Vlookup - using a cell to reference a named array 3
Vlookup and return sheet name also 2
Refer to a named range indirectly 2
Linked Named Ranges 2
a data validation list that contains a list of named ranges - not alist from a named range 1
Using Value of a Cell in the Range Reference in VLOOKUP 1
How do I insert a dynamic reference of a range inside VLOOKUP? 4

Top