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?