Forum Discussion
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
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.
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
2 Replies
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.
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
