|
|
#1
03-02-2012, 12:29 AM
|
|||
|
|||
Vlookup
In the attached file, I am using VLOOKUP in sheet 1 to extract the number of employees belong to each division.
Medical Division was in Department 1 then was transferred to Dept 3 then to Dept 4. I want to add its 3 numbers (500 + 450 + 470) To calculate the average and the maximum number (500). The problem is that VLOOKUP read the 1st record only.  I appreciate your help. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Vlookup & IF together | thelauncher | Excel | 5 | 08-25-2013 11:32 PM |
| Vlookup | ibrahimaa | Excel | 8 | 01-03-2012 09:32 PM |
 Can i do this with a VLookup?
|
foodstudent | Excel | 1 | 01-21-2011 12:34 AM |
| Using IF & VLOOKUP together | junction | Excel | 7 | 11-18-2010 05:15 AM |
| Help with VLOOKUP | sakhtar | Excel | 2 | 07-24-2010 07:39 PM |
Windows Vista 
Office 2007
Threaded Mode