Index matching multiple inputs and returning multiple results

[btucker7587]

BLDG	ROOM	ZONE	BLDG	(input)	Room	(input)
10	204	U02
10	101	U01		Zone	(Return)
22	188	U04			(Return)
10	213	U01
43	110	U10

<tbody>
</tbody>

Having little success trying to get the proper return data.

Using the input of the building and room number, I am trying to get the corresponding zones as a return. There are sometimes multiple returns, so I also need those displayed a well.

I have been able to get a single return using his formula -


=INDEX(A2:C6,MATCH(E1&F1,A2:A6&B2:B6,0),3)

But I have been unsuccessful at getting multiple returns.

Tanks in advance or the assistance.

 

[btucker7587]

They both worked great!

You guys rock! Thanks for the help!