Matching data between two sheets

Hi


I have som problem matching data between two sheets.

Sheet A is where the data should be filled out based on raw data in sheet B. The only match I have is the JobID number. So If JobID in Sheet A and Sheet B match, copy the values in selected columns from sheet B to A

In some cases it is possible that the raw data (sheet B) has more JobID`s than in sheet B, and if that is true, I would like to add it as a new job in Sheet A (after last row). I have made an example in uploaded sheet that explains it more in details.

Thanks for any help!

Elad