I am trying to match partial text in a string with text from a range on another sheet.
The text fragment in the string is usually found after the last comma. For example:
P38 Some Noise Text > Other Noise Text > 12-3456, 7890 Text I Want
The range on the other sheet (Sheet2!$B$2:$B$505) will sometimes contain ONLY this alphanumeric (7890 Text I Want) somewhere in the range, but more often it will be found in a non-matching string, usually at the beginning of the string. Example:
7890 Text I Want MA1309-054-055
I'm struggling to find a formula that will accomplish this. If the partial match is found, I'd like the formula to return the string fragment that matches (7890 Text I Want), or "no" if not found.
The text fragment in the string is usually found after the last comma. For example:
P38 Some Noise Text > Other Noise Text > 12-3456, 7890 Text I Want
The range on the other sheet (Sheet2!$B$2:$B$505) will sometimes contain ONLY this alphanumeric (7890 Text I Want) somewhere in the range, but more often it will be found in a non-matching string, usually at the beginning of the string. Example:
7890 Text I Want MA1309-054-055
I'm struggling to find a formula that will accomplish this. If the partial match is found, I'd like the formula to return the string fragment that matches (7890 Text I Want), or "no" if not found.