A couple of other ways...
1.
Use this formula in C13:
=IFERROR(INDEX($C$2:$M$2,SMALL(IF(INDEX($C$3:$M$7,MATCH($B13,$B$3:$B$7,0),0)>0,COLUMN($C$2:$M$2)-COLUMN($C$2)+1),COLUMNS($C$13:C13))),"")
confirmed with CTRL+SHIFT+ENTER not just ENTER and copied across 11 columns.
Then in C14:
=INDEX($C$3:$M$7,MATCH($B13,$B$3:$B$7,0),MATCH(C16,$C$2:$M$2,0))
confirmed with just ENTER and copied across 11 columns.
or
2.
Add helper row at C8:
=IF(INDEX($C$3:$M$7,MATCH($B13,$B$3:$B$7,0),COLUMNS($C$8:C$8))>0,COUNT($B8:B8)+1,"")
copied across.
Then at C13:
=IFERROR(INDEX($C$2:$M$2,MATCH(COLUMNS($C$13:C$13),$C$8:$M$8,0)),"")
copied across
and at C14, same as above:
=INDEX($C$3:$M$7,MATCH($B13,$B$3:$B$7,0),MATCH(C16,$C$2:$M$2,0))
copied across.
Note: the second option is more efficient, especially if your lists are long....
Bookmarks