How to merge columns by matching respective row

Hi everyone I'm looking for a way to do some merging a very specific way. I've tried looking for a way to do this and everything that I've found is a little different that what I'm trying to do. At this point I'm at information overload and so I need some help to do this. In my mind doing this should be easy, but I just don't know "how" to do it.

So anyway, I'm looking for a way to merge columns from two different spreadsheets while merging the information to its respective row (case#).

Here is the scenario:
-------------------------------------------
spreadsheet #1
spreadsheet1.png
-------------------------------------------
spreadsheet #2
spreadsheet2.png
---------------------------------------------------
spreadsheet #1 << THIS IS WHAT THE END RESULT WOULD LOOK LIKE
spreadsheet1-merged.png
---------------------------------------------------

What I'm trying to do is look up where the case number from the second spreadsheet appears in the first spreadsheet. Then pulling the bedroom and bathroom columns and moving them to the first spreadsheet respective to the case number. What is the simplest way that I would do this. Keep in mind that the second spreadsheet does not contain all of the case numbers (as I've tried to demonstrate in the example)that the first spreadsheet does, so I can't flat-out copy and paste the columns because they would not match up to the correct case number.

Thanks for any help
Nik

try this code from Spreadsheet 1, whilst both the spreadsheets are open.

Please Login or Register  to view this content.