VB Code to look for certain data and bring related data

Hello:
Please refer to attached file.
I have downloaded Bank Statement and data are shown in column A thru G.
I will have Payroll Data in column O thru T.

I need VB Code to go thru each check # in column C and find the name of the Payee from column R for correpsoning check # in column O.
Will need to confirm check # in column C and amount in column G with Check # in column O and Amount in column S.
Once name of the payee is found then enter in column D and add "Payroll:Net" in column E as shown in yellow highlighted.


Let me know if you have any questions.
Thanks.

Riz