hello,

I have the following array formula

=INDEX(INDIRECT("'"&INDEX(DDD,MATCH(TRUE,COUNTIF(INDIRECT("'"&DDD&"'!$A$1:$ir$1"),B5)>0,0))&"'!$A$1:$ir$2000"),MATCH($C5,'D1'!$A$1:$A$2000,0),MATCH(B5,INDIRECT("'"&INDEX(DDD,MATCH(TRUE,COUNTIF(INDIRECT("'"&DDD&"'!$A$1:$ir$1"),B5)>0,0))&"'!$a$1:$ir$1"),0))
when i try to include an IF(ISERROR at the start it errors at the underlined "INDIRECT"

=if(iserror(INDEX(INDIRECT("'"&INDEX(DDD,MATCH(TRUE,COUNTIF(INDIRECT("'"&DDD&"'!$A$1:$ir$1"),B5)>0,0))&"'!$A$1:$ir$2000"),MATCH($C5,'D1'!$A$1:$A$2000,0),MATCH(B5,INDIRECT("'"&INDEX(DDD,MATCH(TRUE,COUNTIF(INDIRECT("'"&DDD&"'!$A$1:$ir$1"),B5)>0,0))&"'!$a$1:$ir$1"),0))),"",(INDEX(INDIRECT("'"&INDEX(DDD,MATCH(TRUE,COUNTIF(INDIRECT("'"&DDD&"'!$A$1:$ir$1"),B5)>0,0))&"'!$A$1:$ir$2000"),MATCH($C5,'D1'!$A$1:$A$2000,0),MATCH(B5,INDIRECT("'"&INDEX(DDD,MATCH(TRUE,COUNTIF(INDIRECT("'"&DDD&"'!$A$1:$ir$1"),B5)>0,0))&"'!$a$1:$ir$1"),0)))
any ideas anyone????

thanks reg