Forum Discussion
Cross referencing 2 Columns, but formula isn't properly working.
I am trying to cross-reference 2 columns. Column G has a list of Specialties and Column I is the column that needs to be checked if any of those terms are in Column G. The formula I am using is ...
Your formula will return a match only if the entire text of I3 occurs within the value of G3, in exactly the same order. G3 does not contain "Cardiology, Interventional Cardiology" exactly like that.
If you are an Office Insider, you can probably use the new text manipulation functions.
Otherwise, you'd have to split column I into multiple columns, with one specialty per column. Or use a custom VBA function.