In F4:
Code:
=INDEX(B6:D8,SUMPRODUCT((B2:D4=F3)*ROW(B2:D4))-ROW(B2:D4)+1,SUMPRODUCT((B2:D4=F3)*COLUMN(B2:D4))-COLUMN(B2:D4)+1)
In F8:
Code:
=INDEX(B2:D4,SUMPRODUCT((B6:D8=F7)*ROW(B6:D8))-ROW(B6:D8)+1,SUMPRODUCT((B6:D8=F7)*COLUMN(B6:D8))-COLUMN(B6:D8)+1)
BOTH Array-Entered, ie. use
Ctrl+Shift+Enter to commit the formulae to the sheet and not just
Enter.
