I am trying to do a lookup and sum values, simultaneously. I posted a
question about this the other day, but didnt get any useful responses. Im
sure the answer is out there somewhere, I just havent found it yet.

I have a sheet named €˜Master and this contains employee IDs in Column A and
the employee name in Column B, and finally the supervisor name in column C.
So, I want to lookup the number in column A and find the corresponding name
in column C. As there will be a few identical numbers in column A, a simple
vlookup or index/match wont work. Once I get the name of the supervisor on
column C, I want to take these and match them to the names in column B of a
sheet named Goals. Finally, I want to find the sum of all the values (which
are goals) that correspond to these names. I know its confusing, thats why
I havent found a solution yet and thats why Im posting this question
again.

In short, I have the name €˜Opie in column B of sheet named €˜Master. Opie
is mapped to €˜Lee and €˜Jay, both in column C. I want to take these names,
€˜Lee and €˜Jay and compare them to names in column B of the €˜Goals sheet
and then sum the goals for €˜Lee and €˜Jay.

Im pretty sure it is going to be something with sumproduct; I just cant
figure it out€¦

If anyone can give me a solution, I would be most appreciative.


Thanks,
Ryan---



--
RyGuy