1 Reply Latest reply on Dec 11, 2016 2:50 PM by Nachiket Dekhane

    Contain string from list

    Pauline Wollseifen

      I have a table with item description ( written by sales teams in a free text format)  and a separate table with item categories. I have over 50000 items and need to assign them a category (there is around 150 categories) - the majority if the description contain the category within the text. I need a formula that say if contain category in string then category. The contain formula allow me to check category one by one but I would like to have somethung that check all.

      Many thanks