I have to extract domain name from email address (like [email protected]) - I need "bigplace" to match with another column (company name "BigPlace") and flag a match or not in another column.

I have tried and tried but I can't get it to work.
Please help me!

CodePudding user response：

Try like this in your Match Column =ISNUMBER(MATCH("*"&B2&"*",A2,0))

CodePudding user response：

What about this:

=NOT(ISERROR(FIND(UPPER(B1),UPPER(A1))>0))

Explanation:

• Apparently in one column you are using small letters, in the other there might be capitals. By capitalising everything, you create a case-insensitive search.
• The result of a FIND() either is a location (a number) or a #VALUE error. Using Not(IsError(... > 0)) is a neat trick to change the format Number/#Value into TRUE/FALSE.