IF CONTAINS WITH MULTIPLE VALUES

[Anonymous]

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

I need a formula in another column that says where in description contains “OWL”, gives me OWL, where contains “EBD” gives me “EBD” and so on.

[v-piga-msft · Accepted solution]

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]

@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.