LookUp Question
YEs this worked great. Thanks.
"willwonka" wrote:
How about this:
=INDEX(INDIRECT(A1),3,11)
Cell K3 = Row 3 and column 11
Does this work?
carl wrote:
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.
|