Finding Approximate Matches

[carlos28669]

Carrier	Ship Via	Match or Mismatch
Sunbelt	No UPS, Sunbelt Only	Match
Fedex	UPS	Mismatch
Fedex	FedEx Account ABCD	Match
UPS	Johnson Trucking	Mismatch

<tbody>
</tbody>

I have scoured several forums including this one trying to find a solution. but have not been successful. Above is What am trying to make happen.
Column M as Carrier info and Column N has Ship Via info. I would like to find away to find approximate matches. Unfortunately the fields will never be identical. Any help or suggestions would be appreciated.

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about

Excel 2013/2016
	M	N	O
1	Carrier	Ship Via	Match or Mismatch
2	Sunbelt	No UPS, Sunbelt Only	Match
3	Fedex	UPS	Mismatch
4	Fedex	FedEx Account ABCD	Match
5	UPS	Johnson Trucking	Mismatch
Orders

Cell Formulas
Range	Formula
O2	=IF(ISNUMBER(SEARCH(M2,N2)),"Match","Mismatch")

 

[carlos28669]

This was perfect worked like a charm. Thank you very much for such a quick response. Truly appreciated and saved me alot of time!

Hi & welcome to MrExcel.
How about

Excel 2013/2016

	M	N	O
1	Carrier	Ship Via	Match or Mismatch
2	Sunbelt	No UPS, Sunbelt Only	Match
3	Fedex	UPS	Mismatch
4	Fedex	FedEx Account ABCD	Match
5	UPS	Johnson Trucking	Mismatch

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Orders​

Worksheet Formulas Cell Formula O2 =IF(ISNUMBER(SEARCH(M2,N2)),"Match","Mismatch") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Fluff]

Glad to help & thanks for the feedback