VLookup sum multiple matches

[NA1980]

Hello,

Trying to figure this one out.

I have data in two worksheets. Worksheet 1 is customers details
Worksheet 2 is vendor details. so I vlook up and match the invoices
However now I want to match the sums. Customer sometimes pays invoice
in increments. I want to sum up those increments so that when i do th
vlookup it retrieves the total sum paid for that particular invoice i a
cross referencing. And then i want to drag down that formula and have i
apply for all invoices.
Can this be done

 

[Don Guillett]

Hello,



Trying to figure this one out.



I have data in two worksheets. Worksheet 1 is customers details.

Worksheet 2 is vendor details. so I vlook up and match the invoices.

However now I want to match the sums. Customer sometimes pays invoices

in increments. I want to sum up those increments so that when i do the

vlookup it retrieves the total sum paid for that particular invoice i am

cross referencing. And then i want to drag down that formula and have it

apply for all invoices.

Can this be done?

You would probably need to use a SUMPROCUCT formula or a macro to filter and copy. Provide a file.