LookUp Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list in ColA. The list is the names of my named tables.

Aug1
Aug2
Aug3
Aug4
Aug7
Aug8


Is there a way to pull out a specific cell in the table. For example, could
a formula in B1 look at A1, find the range named Aug1, and then return the
value in K3 of the range ?

Thank you in advance.
 
How about this:

=INDEX(INDIRECT(A1),3,11)

Cell K3 = Row 3 and column 11

Does this work?
 

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

Macro Modification 2
How can I reference a cell on a previous worksheet 3
A find formul looking at two named ranges for two strings 6
Pivot Table Grouping by Quarter 5
Excel Macro or Formula Question 1
Lookup returning wrong results 0
Lookup / Summary Table 8
Name ranges and Lookup 3

Back
Top