Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
Using VLOOKUP with multiple first column matches | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
multiple entries | Excel Worksheet Functions |