Results 1 to 10 of 10

Finding and subtracting with almost similar product SKUs

Threaded View

ExcellentM Finding and subtracting with... 09-07-2012, 11:58 AM
twiggywales Re: Finding and subtracting... 09-07-2012, 12:02 PM
ExcellentM Re: Finding and subtracting... 09-07-2012, 12:10 PM
twiggywales Re: Finding and subtracting... 09-07-2012, 12:18 PM
ExcellentM Re: Finding and subtracting... 09-07-2012, 12:22 PM
twiggywales Re: Finding and subtracting... 09-07-2012, 12:37 PM
ExcellentM Re: Finding and subtracting... 09-07-2012, 01:23 PM
Pepe Le Mokko Re: Finding and subtracting... 09-07-2012, 01:46 PM
Pepe Le Mokko Re: Finding and subtracting... 09-07-2012, 01:47 PM
ExcellentM Re: Finding and subtracting... 09-07-2012, 02:01 PM
  1. #1
    Registered User
    Join Date
    09-07-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010 Mac
    Posts
    29

    Finding and subtracting with almost similar product SKUs

    Hi all.......New to the forums....

    This task has me a bit stumped, as I'm not yet fluent in formulas. Basically, I have a large column list with product SKUs. The example shows that pairs of SKUs are similar, but one has additional characters for a special version of the product and is more expensive. I'm trying to come up with a formula that finds the higher item (500FBCLIKA-BOD), get the price, and then subtract the price of the similar, lower value SKU (500FBCLIKA).




    A B C
    1 SKU Price Difference
    2 500FBCLIKA 383
    3 500FBCLIKA-BOD 495


    All I could come up with is:

    =VLOOKUP(A2&"-BOD",$A$2:$A$1898,2,FALSE)-A2

    Which of course does not work.

    Any of you Spreadsheet Wizards know what I should be correcting or using?

    Thanks!
    Last edited by ExcellentM; 09-07-2012 at 02:03 PM.

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