Merging two sheets

[Dhruva101]

This is what I have

Sheet 1 has two columns
Col1 ; Col2
Job; program ( combination of Job + program is unique )
ABC4DX; ABC123
ABC4DX; ABC475
AXC123X; AXC123
ABC135x; ABC124






Sheet 2 (This is a super set, has many rows , some are matching to th
sheet 1 and some not , the job + program will have duplicates)

Col1; Col2; Col3; Col4; Col5; Col6
Job; program; DBB; insert; update; lock
ABC4DX; ABC123; PVM; I; ; L
ABC4DX; ABC123; PTM; I; ; L
AXC123X; AXC123; PVX; ; U ; L
AXC123X; AXC234; PVM; I; ;

Matching Key between the two sheets = Job + program

Please note:
The First row of the Sheet1 has two matching rows in Sheet 2 (First tw
rows of sheet2)
The second and fourth row of the sheet1 has no matching in th
sheet2
The third row of the sheet1 has one matching row in the sheet2(3rd ro
of the sheet2)
The 4th row of the sheet2 also has no matching row in the sheet1


What I need:

I need to update the sheet1 bringing Cl3,col4,col5,col6 from sheet2 fo
the matching rows (matching key is job + program)

Should look like this

Job;; program;; DBB;; insert;; update;; lock;;
ABC4DX;; ABC123;; PVM;; I;; ;; L ;; (Brought two rows from Sheet2)
ABC4DX;; ABC123;; PTM;; I;; ;; L ;;
ABC4DX;; ABC475;; NA;; ;; ;; ;; (No row found)
AXC123X;; AXC123;; PVX;; ;; U;; L;; (One row found in sheet2)
ABC135X;; ABC124;; NA;; ;; ;; ;; (No row found)

Can someone help in getting this done

 

[Dhruva101]

Can anyone please look into this problem