VlookUP

Post your workbook.

not sure how,

On the bottom of the "Quick Reply" box on the right there are 3 buttons:
"Post Quick Reply", "Go Advanced" and "Cancel"

Click on "Go Advanced". There you can manage attachments.

workbook for the issue above, thank you guys

I posted my workbook, thank you for your help.

Your initial post is slightly confusing. Also as I look through this, I notice there are doubles of UPC's. Tell me if this is right:

For every UPC entered by a user you want to return the sum of (Dollar SalesCurrent)*(Unit SalesCurrent) for all entries matching the entered UPC?

Yes there are double entries of UPC. So what I need is to figure out a formual that will find the UPC's, and add up the sales and units that corespond to each UPC. For example: upc-444444 (I need to find all upc's that match this) then have it add up all sales and units, no need to multiply in this case.

ok,

So because of the duplicates you have, I think its a better idea if you sort the data first with a pivot table. Once thats done then the vlookup can be done no problem.

Take a look and let me know if thats what you wanted or if you want further explanations

Hey Scottylanes-- There is definitely more than 1 way to resolve your issue. I have another suggestion. Remove all duplicate upc codes through excel. Paste onto another tab-- then sumif each one to show total. Here you go-- hope this helps too

thanks everyone! I justed each of your examples and they worked really well, I really appreciate it!