LookUp Question

C

carl

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.
 
W

willwonka

How about this:

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

Cell K3 = Row 3 and column 11

Does this work?
 
Top