I have two columns. One column has complex labels and the other has simple labels. For example, the complex labels might look like "Complex Label: WORD-12345 Blah blah blah", whereas the simple label would just say "WORD".

If "WORD" is contained in any complex label, I'd like to tag that item. Now, I've tried a formula like this: =IF(ISERROR(MATCH())) , but I can't seem to get it to work with partial values.

I've attached an example file to help make this clearer. Excel Matching Example.xlsx