LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down menu and two dimensional lookup in Excel 2003 THE BIG O Excel Worksheet Functions 8 February 9th 06 08:37 PM
Does 2003 excel have training on V Lookup Matt Franc Excel Worksheet Functions 4 September 28th 05 08:12 PM
In Excel 2003 how do you get a table to update based on lookup cr. cliveshelton Excel Worksheet Functions 0 April 20th 05 04:24 PM
can i delete "lookup" from right-click in excel 2003? aarria Excel Worksheet Functions 1 February 22nd 05 05:34 PM
Lookup function in Excel Feldy Excel Worksheet Functions 4 February 17th 05 04:25 PM


All times are GMT +1. The time now is 02:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"