Merging a row in a specific position

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

-------------------------------------------
spreadsheet #2 << info that will be added to spreadsheet #1

---------------------------------------------------
spreadsheet #1 << THIS IS WHAT THE END RESULT WOULD LOOK LIKE

---------------------------------------------------

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 function ...

Hi,

Try Vlookup function with iferror.

=IFERROR(VLOOKUP(C5,[spreadsheet#2]Sheet1!$A$1:$D$5,2,0),"")

Just copy paste function into spreadsheet#1.

considered data in spreadsheet#2 , state in column A1.

Thanks
Tanuj