| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function gives wrong values occasionally | Excel Discussion (Misc queries) | |||
| How can I isolate a lookup vectors but not values from autofill? | Excel Worksheet Functions | |||
| LOOKUP a text string created from IF statement | Excel Discussion (Misc queries) | |||
| Lookup Type Question | Excel Worksheet Functions | |||
| Formula Question... LookUP | Excel Discussion (Misc queries) | |||
Linear Mode
