VLookup sum multiple matches
 

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?

VLookup sum multiple matches
 

On Monday, October 8, 2012 10:45:47 AM UTC-5, NA1980 wrote:
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?









--

NA1980

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