In this case I would probably opt for

E4:
=LOOKUP(REPT("Z",255),CHOOSE({1,2},"",LOOKUP(2,1/(($A$3:$A$29=E$3)*($B$3:$B$29=$D4)),$C$3:$C$29)))
applied across matrix
Depending upon the quantity of info in your "real" file (and subsequent matrix dimensions) it may be worth considering use of helpers to generate the matrix.