Index/Match with multiple criteria

I have been trying to use INDEX/MATCH without success. I have also tried putting the data in a Pivot Table and using GETPIVOTDATA. I have attached a sample workbook. I need to Match the PIN numbers on the Detail and Payroll and have the totals from the Payroll entered on the correct column of the detail. There will be PIN numbers on the Payroll spreadsheet that do not match or are not listed on the Detail spreadsheet. I also need some kind of formula to highlight these numbers.

I would appreciate help.

Thanks

Thank you so much. Works perfectly!