I am providing a solution to your request but I think your overall design is a problem. Why do you have two separate worksheets with all the same data on each one? Why can't you just enter this data on a single worksheet?
We recommend against using merged cells. I have unmerged your cells to be able to create this solution, but kept the same appearance.
The formula is
Formula:
=INDEX(Parking!$A:$A,MATCH(Building!A15&" "&Building!C15,Parking!$D:$D,0))&" "&INDEX(Parking!$B:$B,MATCH(Building!A15&" "&Building!C15,Parking!$D:$D,0))
Bookmarks