Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

IF CONTAINS WITH MULTIPLE VALUES

I have a filed Job Description for example:   NGN NATRX272 - (Slough - Manchester) STAGING OWL - BTWB100200 TeleCity Pr / Rugb Pr   And I have Group Portfolio:   OWL NGN EBD LAPWING     ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    The suggestion of PattemManohar is helpful.

    By my tests, you also could refer to the fomula below.

    Have you solved your problem?

    If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

    If you still need help, please feel free to ask.

    Best Regards,

    Cherry

     

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous Please try with SEARCH function to check the patterns and SWITCH statement to return the final result. Any sample test data with atleast 10 rows will be helpful to provide you an accurate solution.