+ Reply to Thread
Results 1 to 2 of 2

Trying to create a formula that looks to the next value if first criteria is not found

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    florida
    MS-Off Ver
    2013
    Posts
    19

    Trying to create a formula that looks to the next value if first criteria is not found

    I have a formula that is listing whether or not a sales deal is active, but I just realized that some of the ship IDs in (Deals! G:G) are blank, when searching with (Pricing Lookup '!$B$1). My question is when Deals!G:G is blank can I have it search (Pricing Lookup '!$B$3) searching in (Deals!K:K) next? The current formula is looking up ship to location and checking for a sales deal, I would like the new formula to check that first but if blank then search the sold to to check for a sales deal. I have either a sales deal for the ship to or a sales deal for the sold to.

    =IF(COUNTIFS(Deals!G:G,'Pricing Lookup '!$B$1,Deals!N:N,'Pricing Lookup '!$A9,Deals!E:E,"<=" &'Pricing Lookup '!$B$6,Deals!F:F,">=" &'Pricing Lookup '!$B$6),"Active","")
    Last edited by bbeards2; 10-26-2015 at 01:45 PM. Reason: NEED HELP!

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Trying to create a formula that looks to the next value if first criteria is not found

    Please attach a sample of your workbook so we can test solutions using your own data. Remember to remove/replace any sensitive info before uploading the file.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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