Finding Approximate Matches

[carlos28669]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Carrier
[/TD]
[TD]Ship Via
[/TD]
[TD]Match or Mismatch
[/TD]
[/TR]
[TR]
[TD]Sunbelt
[/TD]
[TD]No UPS, Sunbelt Only
[/TD]
[TD]Match
[/TD]
[/TR]
[TR]
[TD]Fedex
[/TD]
[TD]UPS
[/TD]
[TD]Mismatch
[/TD]
[/TR]
[TR]
[TD]Fedex
[/TD]
[TD]FedEx Account ABCD
[/TD]
[TD]Match
[/TD]
[/TR]
[TR]
[TD]UPS
[/TD]
[TD]Johnson Trucking
[/TD]
[TD]Mismatch
[/TD]
[/TR]
</tbody>[/TABLE]


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
Carrier	Ship Via	Match or Mismatch
Sunbelt	No UPS, Sunbelt Only	Match
Fedex	UPS	Mismatch
Fedex	FedEx Account ABCD	Match
UPS	Johnson Trucking	Mismatch

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]5[/TD]

</tbody>

Orders​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O2[/TH]
[TD="align: left"]=IF(ISNUMBER(SEARCH(M2,N2)),"Match","Mismatch")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Glad to help & thanks for the feedback