ExcelBanter - LookUp Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - LookUp Question (https://www.excelbanter.com/excel-worksheet-functions/108050-lookup-question.html)

Carl

LookUp Question

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.

willwonka

LookUp Question

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.

Carl

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.

All times are GMT +1. The time now is 04:40 AM.