formula to look up employee name and return reoccuring net pay

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

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?
 
Back
Top