How can I match text from different excel column?

[codenameSRJ]

Dear Altruist,
I hope you are doing well in this pandemic situation. Recently I'm working as an audit assistant in an audit firm. My colleague sent me a file regarding the address of several branch offices of an Insurance company. The attached file shows several branch offices in two different columns. The sheet is very large so I just upload the first page.
My requirement is to identify similar branch office from B and M column. For example, B2 Bogra is similar to M2. Both the column consists of 1300 branch. So it is difficult for me to identify it one by one.
Is it possible to make any formula or other ways to identify similar names? Thanks In Advance.

 

[mrshl9898]

Try =INDEX(B:B,MATCH("*"&M2&"*",B:B,0),1)

 

[sandy666]

or

Download Fuzzy Lookup Add-In for Excel from Official Microsoft Download Center

The Fuzzy Lookup Add-In for Excel performs fuzzy matching of textual data in Excel.

www.microsoft.com