Error in Indirect function

[Ufoo]

Hello gurus, I need your help with the formula in the attached sheet. The formula is working perfectly in Sheet named daftari la fedha cells C5:G21, but is return an error in the same sheet in cells I5 to J21. Please help me figure out the problem. I have struggled!! I have failed to detect where I have messed up. Thanks.

 

[bosco_yip]

Try,

In I5, copy across right to J5 and all copy down :

=INDIRECT("'"&SUBSTITUTE(I$4," ","")&"'!"&ADDRESS(28,ROW(A1)+(MATCH($B$5,Akiba!$A$2:$BL$2,0))-1))

Regards

 

[Ufoo]

Try,

In I5, copy across right to J5 and all copy down :

=INDIRECT("'"&SUBSTITUTE(I$4," ","")&"'!"&ADDRESS(28,ROW(A1)+(MATCH($B$5,Akiba!$A$2:$BL$2,0))-1))

Regards

It works perfectly @bosco_yip. Thanks. Do you have a clue why my formula failed please?