Simplify Array formula

[ExcelRoy]

Hi,

Can i please ask if i can simplify the following formula

=IF(H11<>"",IFERROR(INDEX(Database!$E$1054:$E$16053,SMALL(IF(Database!$H$1054:$H$16053=H11,IF(Database!$I$1054:$I$16053=T11,ROW(Database!$C$1054:$C$16053)-ROW(Database!$C$1054)+1)),ROWS(X$11:X11))),""),"")

to remove the following
IF(Database!$I$1054:$I$16053=T11

Many thanks

 

[Eric W]

Try:

=IF(H11<>"",IFERROR(INDEX(Database!$E$1054:$E$16053,SMALL(IF(Database!$H$1054:$H$16053=H11,ROW(Database!$C$1054:$C$16053)-ROW(Database!$C$1054)+1),ROWS(X$11:X11))),""),"")

 

[ExcelRoy]

Thanks Eric W