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.

Attached Files

Test1.xlsx (9.9 KB, 20 views)