Using the text from a cell as a range name in a formula

G

Guest

I would like to create a forumla that uses the text from column A to be the
source for the named range in my forumla in column B.

For example, I have a spreadsheet where coulmn A has rows each with the name
of a city (branch location). I have a seperate table of data that has named
ranges (named by city). Can I write a LOOKUP formula that uses the text in
column A to be the source of the named range inside the formula. Referring
to the text in column A would save me the effort of typing the named range in
each formula

FYI - I don't think A pivot table would work for creating this spreadsheet
because the data is exported from another application and isn't in a friendly
format.
 
G

Guest

=Lookup(indirect(A1),...)
or
=LOOKUP(E3,INDIRECT(A1),...)
etc.

Indirect function treats text as references.
Bob Umlas
 
B

Biff

Hi!

Try this:

=VLOOKUP(lookup_value,INDIRECT(A2),2,0)

Where A2 = city_name and city_name is the named range.

Biff
 

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

How to take text from other cells to create a reference to a name 3
Looking up a returned value defining a named range 2
Losing a named range 3
how do i use the text in a cell as a named range in a vlookup form 2
Cell reference in formula as range 4
Can I use a named range in SUMPRODUCT? 2
Name Manager For A Lookup 4
Formula to return a value for a portion of a text string in a cell 2

Top