How to match concatenated string in a column

[Anonymous]

Dear All

I have a column -  'Code' . It has values like the attached screenshot. There are multiple codes in a single record field.

I want to check these codes against a mapping sheet and if the code matches between the field and mapping sheet it returns true else false.

Eg)  BOM-HYD/BLR-BOM.   is one of the record in the column. 

        IF either of BOM or HYD or BLR is available in mapping sheet then it should return TRUE. If not false.

Is it possible to search the records in above way. Kindly help me.

Thanks & Regards

Chintan

[arvind1494]

use if statement

[Anonymous]

Its not working..