btucker7587
New Member
- Joined
- Dec 15, 2014
- Messages
- 5
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.