+ Reply to Thread
Results 1 to 3 of 3

Desparate SUMIF and VLOOKUP combination?

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Desparate SUMIF and VLOOKUP combination?

    Hi,

    I have uesd this great forum several times to find answers to general questions but this time I could not figure out how to solve my problem by checking others post. So here is mine.

    I have two sets of data. Orders and current stock. I want to match orders with the stock and see how much I have in stock for every article number and return the stock amount. The problem is that the same article number might appear several times in the stock and therefore I need to SUM the total amount in stock which matches with the article numbers.

    Also. I want to write the markup price where I compare cost of good to price to customer with a simple price/cost (but need to match with right article number).

    Please help me out as I need to deliver these results rather quick.

    BTW: I would also want to ask how to use the Vlookup formula or similar to match information that is ALMOST the same and the same. Example if ABC1234567 and 1/ABC1234567 are in two different columns I would still like the formula to identify them as equal. Is it possible?
    Attached Files Attached Files
    Last edited by vmansson; 07-31-2012 at 06:07 AM.

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286

    Re: Desparate SUMIF and VLOOKUP combination?

    Use =SUMIF($H$5:$H$10,$B5,$I$5:$I$10)

  3. #3
    Registered User
    Join Date
    07-31-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Desparate SUMIF and VLOOKUP combination?

    Thank you for a quick reply. Do you have any solution on the "Similar article number" problem?

+ Reply to Thread

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