Thread: formula to look up employee name and return reoccuring net pay
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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?
Reply With QuoteReply With Quote