• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Finding out if an order contains certain sku's

    Could I use a countif statement with the range of sku's and set the criteria to the order list? If so how would I set the criteria to search the order list
  2. J

    Finding out if an order contains certain sku's

    *scratching head also* not sure how to check but when I dragged the lower right corner down in the test data it worked fine.
  3. J

    Finding out if an order contains certain sku's

    Yes I see the curly brackets in the formula bar, but still same issue
  4. J

    Finding out if an order contains certain sku's

    Hi Luke, Using the code above I got all YES Using this code =IF(OR(ISNUMBER(SEARCH($G$2:$G$35000,D2))),"yes","no") I get all no.
  5. J

    Finding out if an order contains certain sku's

    Hi Luke =IF(ISERROR(LOOKUP(999,FIND($G$2:$G$35000,D2,1))),"NO","YES") the g$ list doesn't have any blanks, and only one sku in each cell
  6. J

    Finding out if an order contains certain sku's

    Yes I altered the data range
  7. J

    Finding out if an order contains certain sku's

    Hi shrivallabha your solution worked for the test data, but didn't work for the actual. Could the size of the data be an issue. I have roughly 200 daily orders and more than 30,000 skus in the compare list
  8. J

    Finding out if an order contains certain sku's

    Hi Here is a link with some test data https://hotfile.com/dl/172993766/9c54881/test_data.xls.html
  9. J

    Finding out if an order contains certain sku's

    I tried your solution and all the values return no, where about 70% should be yes. Does it matter that the sku's are text and numbers mixed together?
  10. J

    Finding out if an order contains certain sku's

    I have a list of orders that have items ordered listed by sku's in one cell separated by commas. Some orders have only 1 sku, other may have more than ten. I want to compare each order to a long list (column, 1 sku per cell) to find out if the order contains one of those sku's. I just need...
Back
Top