vlookup with multiple duplicate values

I have a data sheet "main page" formatted like this:

Attachment 189817

And another sheet "cost list" with data formatted like this:

Attachment 189818

The main page uses the cost list sheet in a vlookup to input cost data back to the main sheet.

The problem I'm having has to do with multiple items ordered from the same buyer (highlighted in green) and how I add correct cost data since there will be duplicate names with differing cost data on the cost list. A straight vlookup will only return the first value.

Since the cost amount and customer name is currently the ONLY identifying information available on the cost list, I figure the best way to do this is to combine the rows with the same buyer name and add the cost data together (let me know if you have a better idea). Then do the same on the main page with the price (revenue) columns. Then process the vlookup which provides the total cost of the order to the main page.

How do I do this as a part of a macro?

Finally, is there a way to change the product column to "combined order" and simultaneously add a comment which has all individual Products listed?

Originally Posted by FDibbins

unless you want to take the chance of being sent a picture of your solution, i would suggest you upload the sample workbook, not a picture of it

Pretty basic workbook, the file is too large...running into problems. And yeah I'd take a chance with a picture...as long as its of code...better than nothing.

Originally Posted by martindwilson

have you tried sumifs

I haven't, the only thing is the solution would need to reformat all the rows and stuff too. I was hoping for a macro solution...still learning macros.