How to match two values and then display multiple rows relating to match?

Hi,

I want to do something similar to an HLOOKUP - but instead of displaying one value from a given row, I want to display a number of rows relating to that match.

Example attached - any help gratefully received!

Try:

=INDEX($B$4:$E$9,ROWS($A$1:$A2),MATCH(B$15,$B$4:$E$4,0))

copied down.

To hide 0's you can format cells as Custom: 0;-0;;@