Hi,
I have two worksheets Source info and transactions.

I need help making a formula that searches Column C (Employee name) for Bob
Someone of the source worksheet, and will return Column J (netpay) of source
worksheet to Column B (Net pay) of the transactions worksheet.
I need this formula to work for each week.

I enter all payroll for each employee every week in the Source worksheet.

Any ideas?