formula to look up employee name and return reoccuring net pay

[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?

 

[Gary''s Student]

Use VLOOKUP(). See:

http://www.cpearson.com/excel/TablesAndLookups.aspx