Merge and modify data from original report to result sheet

[3006elk]

I have been working on this a while and finally asking for help. I have a payroll report that I need to modify to allow us to upload payments. The payroll report is labeled "Report" and I need it to look like the "Result" sheet. In addition to removing columns, removing duplicates and merging data I need to perform the following to get the correct result. Hopefully someone can help.

Result Sheet
Column C = (IF(OR(E2 = "REM",E2= "RET") Then Value from Report K2)

Result Sheet
Column D = (IF E2 From Report = "EMM" Then Value from Report L2 )

Result Sheet
Column E = (IF(OR(E2 = "ROT",E2= "RTH"), Then Value from Report K2)

 

[Sam_D_Ben]

That worked great Sam -- you are awesome. Really appreciate the help!

No Problem, have a good one!