Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect/match formula - array
{=INDEX(PAYECalc!F$1:F$300,MATCH(1,(PAYECalc!$A$1: $A$300=$A24)*
(PAYECalc!$C$1:$C$300=$C24),0))} Would like to replace the above array formula with the formula below using "indirect" where cell F1 contains the sheet name "PAYECalc" - but get an error message {=INDEX(INDIRECT(F$1&"!F$1:F$300",MATCH(1,(INDIREC T(F$1&"!$A$1:$A$300= $A24")* (INDIRECT(F$1&"!$C$1:$C$300=$C24"),0)))} Could someone correct my alternative formula pls thxs |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect/match formula - array
al wrote:
{=INDEX(PAYECalc!F$1:F$300,MATCH(1,(PAYECalc!$A$1: $A$300=$A24)* (PAYECalc!$C$1:$C$300=$C24),0))} Would like to replace the above array formula with the formula below using "indirect" where cell F1 contains the sheet name "PAYECalc" - but get an error message {=INDEX(INDIRECT(F$1&"!F$1:F$300",MATCH(1,(INDIREC T(F$1&"!$A$1:$A$300= $A24")* (INDIRECT(F$1&"!$C$1:$C$300=$C24"),0)))} Could someone correct my alternative formula pls thxs Looks like misplaced quotes and parens. Try this: =INDEX(INDIRECT(F$1&"!F$1:F$300"), MATCH(1,(INDIRECT(F$1&"!$A$1:$A$300")=$A24)* (INDIRECT(F$1&"!$C$1:$C$300")=$C24),0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect & Match Formula Problem | Excel Discussion (Misc queries) | |||
Indirect function in Index/Match Array | Excel Discussion (Misc queries) | |||
What is ROW(INDIRECT("1:40")) doing? (array formula) | Excel Worksheet Functions | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
Indirect used in an array formula | Excel Worksheet Functions |