I would like to compare two columns to find matching text, and if there is, return "Match" on third column.
For example:
In A1:
XY12345 Cats and Dogs
In B1:
Batman with the Flash 12345
Since they both contain "12345", I will get "Match" in C1
Please tell me how to accomplish this with a formula. Thank you
For example:
In A1:
XY12345 Cats and Dogs
In B1:
Batman with the Flash 12345
Since they both contain "12345", I will get "Match" in C1
Please tell me how to accomplish this with a formula. Thank you