View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Newfie809 Newfie809 is offline
external usenet poster
 
Posts: 61
Default Excel 2003 Lookup function

I have a spreadsheet with a list of Employees sometimes these employee are
listed more that once. I would like to perform a lookup on another worksheet
to add up their FTE and put it in one cell. A1 Employee B1 .50, A2 Same
Employee B2 .25, A3 Same Employee B3 .25, for a total of 1.0 Full Time Equ.
Do you know what formula I would use to lookup the name of the employee and
return the total of the FTE to one cell on a different spreadsheet.

Thanks.
--
Newfie