You can create a helper column between the Product_Code and Program_Code columns that concatenates the Contract_ID and the Product_Code...then use that in your Vlookup.

E.g =Vlookup(A1&B1,Sheet2!C1:D100,2,0)

where A1&B1 are your input ID and Code and Sheet2!C1:C100 contain the concatenated items.