Getting a named range from a cell value

  • Thread starter Thread starter Charles Woll
  • Start date Start date
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
 
=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

Vlookup and return sheet name also 2
Ifcount + and 7
Scrabble Value calculation for Welsh words 0
Vlookup - using a cell to reference a named array 3
Linked Named Ranges 2
How do I insert a dynamic reference of a range inside VLOOKUP? 4
Vlookup array formula problem 2
a data validation list that contains a list of named ranges - not alist from a named range 1

Back
Top