VLOOKUP - or other - that totals results that match

Hello all,

I'm not sure the title is as clear as possible, but I'm not really sure how to explain this without pictures, so here goes!

Picture one shows the first spreadsheet in Workbook 1. This is a long list with two identifier codes in columns A & E, and an amount in column H. When the codes in A & E are merged (as in column G) it more often than not produces a unique code, but some are duplicated.
Spreadsheet.jpg

Now onto the second spreadsheet in Workbook 2. By using VLOOKUP - or another function if it's better for the job - I want to look up the codes in A3 & C1, A4 & C1, A5 & C1 etc on the first workbook, and have the amounts appear in the 'Oct' column.
Picture2.jpg

I've been able to do this when the code in workbook 1 in column G has been unique, but with code 'ABC123A1234B' for example, there are two lines in workbook 1. What would I have to use - if anything works - to look this up from workbook 2, add the two amounts together, and produce them in cell C3 in workbook 2?

Many thanks in advance!

Please note, while the example comes from Office 2013, I'll actually need it to work in 2003! From the ark, I know...

Hey,

I am not sure if you use commas or semicolons in Formulas in England so you may have to adapt that.

Please Login or Register  to view this content.

Julian

unsuitable_ - Thank you so much! That worked perfectly!

I've now come across a slightly more complicated issue. On the second screenshot where I have 'Code 2' I now have 27 codes there instead of 1. I tried using your formula 27 times with '+' in between, but it only let me do about 9 before it tells me the formula is too long.

Any ideas?

Please post a small sample illustrating the outcomes you want.

Click "Go Advanced" the paper Clip icon to upload a file.

Basically I want exactly what I described in the first post, and what the formula that unsuitable_ provided me with does, except that image two has now changed to this:

Excel.png

Many of us cannot view images so please upload a file.