formula to look up employee name and return reoccuring net pay
 

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?

formula to look up employee name and return reoccuring net pay
 

Use VLOOKUP(). See:

http://www.cpearson.com/excel/TablesAndLookups.aspx
--
Gary''s Student - gsnu200832


"Joe" wrote:

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?