Hi,

I get a report everyday. It has a list of all the names in column A and some
values in columns B and C. I paste this report on Sheet2 of a workbook which
has names of my team members on Sheet1. The report that I get might (or
might not) have the names repeated based on the queues the person worked on.
For example if one of my team members worked on more than one Queues, the
report will have his/her name and the values in column B and C twice or
thrice.

In Sheet1, I want to return the total value for that particular name. If the
name appears once, simply return the corresponding values from B and C (this
can easily be done by VLOOKUP) But if the name appears more than once,
return the SUM of all the values corresponding to that name.

I hope the question is clear and understandable.

Thanks