LOOKUP and "nesting" IF formula troubles

See attached for a proposal...

I added a helper column to Workbook 1 (column D)

In D9:

=MATCH(TRUE,INDEX($F9:$I9<0,0),0)

copied down

Then in Workbook 2:

In E20:

=IF(ROWS($E$20:$E20)>SUMPRODUCT(--ISNUMBER($D$9:$D$13)),"",INDEX($E$9:$E$13,SMALL(IF(ISNUMBER($D$9:$D$13),ROW($E$9:$E$13)-ROW($E$9)+1),ROWS($E$20:$E20))))

which is confirmed with CTRL+SHIFT+ENTER not just ENTER. Then copied down

In F20:

=IF(E20="","",INDEX($F$8:$I$8,INDEX($D$9:$D$13,MATCH(E20,$E$9:$E$13,0))))

copied down

In G20:

=IF(E20="","",INDEX($F$9:$I$13,MATCH(E20,$E$9:$E$13,0),INDEX($D$9:$D$13,MATCH(E20,$E$9:$E$13,0))))

copied down

These formulas can be adjusted to suit your "real ranges"