| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDIRECT
I have the following formula which works fine:
=INDEX(February!A1:Z100,MATCH("USD",February!A:A,0 ),MATCH("AUD",February!4:4,0)) I would like February to be the variable contents of a particular cell but cant get my referencing right. Can anyone please help?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INDIRECT
You may try this with Indirect (supposing "February" is on cell AA1):
=INDEX(INDIRECT(AA1 & "!A1:Z100"),MATCH("USD",INDIRECT(AA1 & "!A:A"),0),MATCH("AUD",INDIRECT(AA1 & "!4:4"),0)) "Newbie" wrote: I have the following formula which works fine: =INDEX(February!A1:Z100,MATCH("USD",February!A:A,0 ),MATCH("AUD",February!4:4,0)) I would like February to be the variable contents of a particular cell but cant get my referencing right. Can anyone please help?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INDIRECT
Thanks Miguel.
=INDEX(INDIRECT(AA1 & "!A1:Z100"),MATCH("USD",INDIRECT(AA1 & "!A:A"),0),MATCH("AUD",INDIRECT(AA1 & "!4:4"),0)) "Miguel Zapico" wrote: You may try this with Indirect (supposing "February" is on cell AA1): =INDEX(INDIRECT(AA1 & "!A1:Z100"),MATCH("USD",INDIRECT(AA1 & "!A:A"),0),MATCH("AUD",INDIRECT(AA1 & "!4:4"),0)) "Newbie" wrote: I have the following formula which works fine: =INDEX(February!A1:Z100,MATCH("USD",February!A:A,0 ),MATCH("AUD",February!4:4,0)) I would like February to be the variable contents of a particular cell but cant get my referencing right. Can anyone please help?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 different INDIRECT data validation lists from one | Excel Discussion (Misc queries) | |||
| Copying a formulae down a column that includes an INDIRECT | Excel Discussion (Misc queries) | |||
| Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
| Indirect function - Limitations | Excel Worksheet Functions | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Linear Mode
