Vlookup on multiple similar entries / NO VBA

[cedequ]

Unfortunately, I am not in a position where I can use VBA Code t
resolve this problem....: Hope anyone of you is willing to provide tip
& tricks to resolve this question:


From one workbook, I am vlooking up a second workbook, but I do no
simply
need to retrieve one similar entry, but all of them! On each simila
entries, I need to calculate a value by using two adjacent cells: Atth
end, I need the total for
each row I.e.:

first book contains:
john
harv
pete

second book:
john|100|40|
john|200|50|
john|500|10|
harv|104|41|
harv|212|11|
pete|100|30|


Ther result for John would be : 100+40+200+50+500+10, copied
in the first workbook, next to his name.


Anyone's help would be appreciated, but pls without VBA (no for eac
and so on)

Thnaks in advance for your precious support.

Ce

 

[Guest]

try somehing like
for the sake of argument hve the names in Column A in both sheets starting
in row two
in sheet 1
in B2 enter
=countif(Sheet2!A:A,A2,Sheet2!B:B)+countif(Sheet2!A:A,A2,Sheet2!C:C)
and copy down to the end of your lisy of names.