ExcelBanter - Indirect/match formula

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Indirect/match formula - array (https://www.excelbanter.com/excel-programming/431707-indirect-match-formula-array.html)

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

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

Answered in MPEWF:

http://preview.tinyurl.com/nnse6n