INDEX array formula using multiple criteria, * and INDIRECT references, Can it work?

Not sure on the technicalities of the forum rules here but....

The formula that I got in the above help from misrasomendra was great and efficient (your awesome!), however, if there is no value in the referenced cell (F2 or F3) it returns odd (weird) values. This is because it tries to return rows that have no entries.

Is it possible to rejig this formula to allow it to skip entry less rows (as in a blank value for F2 or F3)

Here is the code directly from her/his answer:

=IFERROR(INDEX(INDIRECT($D4&"!A2:A500"),SMALL(IF((INDIRECT($D4&"!F2:F500")=$E$2)+(INDIRECT($D4&"!F2:F500")=$E$3),ROW(INDIRECT($D4&"!F2:F500"))-2+1),COUNTIF($D$4:$D4,$D4))),"")

Here is the spreadsheet:

353354d1413915941-index-array-formula-using-multiple-criteria-and-indirect-references-can-it-wo.xlsx

Many thanks again!

Just to add... I did spend some 3 hours on this today with results ranging from breaking excel to nearly set PC on fire... I will need to spend some time after this getting my head around this new formula... for now though I need to get this out by Friday.. lol