You could perhaps revert to something along the lines of:
J3:
=LOOKUP(2,1/($B$1:INDEX($B:$B,LOOKUP(2,1/($B$1:$B$1744=J$1),ROW($B$1:$B$1744)-1))=J$1),$C$1:$C$1744)
copied across to N3
J4:
=LOOKUP(2,1/($B$1:$B$1744=J$1),$C$1:$C$1744)
copied across to N4
or if you prefer a single formula which can be applied to J3:N4 you could use an Array, ie:
J3:
=INDEX($C$1:$C$1744,MATCH(LARGE(IF($B$1:$B$1744=J$1,$A$1:$A$1744),3-ROWS(J$8:J8)),$A$1:$A$1744))
confirmed with CTRL + SHIFT + ENTER
applied across matrix J3:N4
Bookmarks