Vlookup on multiple similar entries / NO VBA
 

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


From one workbook, I am vlooking up a second workbook, but I do not
simply
need to retrieve one similar entry, but all of them! On each similar
entries, I need to calculate a value by using two adjacent cells: Atthe
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 each
and so on)

Thnaks in advance for your precious support.

Ced


--
cedequ
------------------------------------------------------------------------
cedequ's Profile: http://www.excelforum.com/member.php...o&userid=26786
View this thread: http://www.excelforum.com/showthread...hreadid=400400

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.

"cedequ" wrote:


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


From one workbook, I am vlooking up a second workbook, but I do not
simply
need to retrieve one similar entry, but all of them! On each similar
entries, I need to calculate a value by using two adjacent cells: Atthe
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 each
and so on)

Thnaks in advance for your precious support.

Ced


--
cedequ
------------------------------------------------------------------------
cedequ's Profile: http://www.excelforum.com/member.php...o&userid=26786
View this thread: http://www.excelforum.com/showthread...hreadid=400400