Hi,
I need help creating a formula to lookup one employee's name and display
their weekly net pay.


I need the formula on the transactions worksheet to search for one
employee's name in the source info worksheet and return the data in a cell
associated with their name, and return that to the transactions worksheet.

They have reoccuring weekly transactions and I need each weeek displayed
seperatly on the transactions worksheet

Example:
I need the transaction worksheet to serach for Bob Somone in Column C of the
source worksheet, and return the value that is associated with Bob Somone
from Column J of the source worksheet.

And I need that to be done for each week.

Any ideas?