Results 1 to 11 of 11

VlookUP

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    9

    VlookUP

    Hello guys, I'm new on here but I've read great things about this forum. I would like to see if you guys could help me out. I am trying to come up with a formula (vlookup) that will look up a upc and that every upc it finds that matches,(this is where I get lost) it should add up the unit sales and dollar sales and give me a final amount. I hope you all understand what I'm trying to say, I've been at it all day and can't seem to figure it out. Thank you in advance!

    Also, I can't seem to find a way to add on the spreadsheet so everyone can see what I'm working with, if you know how, please tell me.

    In the end, I would like to have the totals of the 52 week and 4 week dollar sales and units sales but under 1 upc, as you can see in the workbook, there is a upc for 4 week and 52 week, so I need a formula that will find any duplicate upc's and at the same time add the dollars and units to be able to just have 1 upc/product/dollars/units and the last two taps I would just have 52 week and 4 week, please let me know if you guys understand this, I get lost my self sometimes lol
    Last edited by scottylanes; 11-30-2012 at 12:12 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1