fuzzy match on a column

%3CLINGO-SUB%20id%3D%22lingo-sub-1286025%22%20slang%3D%22en-US%22%3Efuzzy%20match%20on%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1286025%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%202%20columns%20of%20data%2C%20see%20test%20file%20below.%20Column%20A%20has%20names%20of%20colleges%20provided%20by%20a%20vendor.%20Column%20B%20has%20names%20of%20colleges%20from%20my%20database.%20In%20A%20many%20are%20the%20same%20college.%20I%20have%20700%20names%20in%20B%20but%20they%20have%20abbreviations.%20For%20example%2C%20Sacred%20Heart%20University%20in%20A%20and%20Sacred%20Heart%20Univ%20in%20B.%20I%20need%20a%20formula%20to%20compare%20the%20name%20in%20A2%20to%20name%20in%20column%20B%20and%20if%20it's%20close%20return%20back%20the%20name%20in%20column%20B.%20Anyone%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1286025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1289649%22%20slang%3D%22en-US%22%3ERe%3A%20fuzzy%20match%20on%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1289649%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F584261%22%20target%3D%22_blank%22%3E%40KMorrison5151%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20previous%20versions%20of%20Excel%20it%20was%20Fuzzy-Match%20add-in%2C%20but%20doesn't%20supported%20any%20more.%20For%20recent%20version%20fuzzy%20match%20is%20built%20into%20the%20Power%20Query%2C%20but%20it's%20not%20very%20reliable.%20You%20may%20check%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1291657%22%20slang%3D%22en-US%22%3ERe%3A%20fuzzy%20match%20on%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1291657%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3Ethank%20you%20for%20pointing%20me%20in%20the%20right%20direction.%20I%20will%20learn%20how%20to%20use%20Power%20Query!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I have 2 columns of data, see test file below. Column A has names of colleges provided by a vendor. Column B has names of colleges from my database. In A many are the same college. I have 700 names in B but they have abbreviations. For example, Sacred Heart University in A and Sacred Heart Univ in B. I need a formula to compare the name in A2 to name in column B and if it's close return back the name in column B. Anyone?

2 Replies
Highlighted

@KMorrison5151 

For the previous versions of Excel it was Fuzzy-Match add-in, but doesn't supported any more. For recent version fuzzy match is built into the Power Query, but it's not very reliable. You may check attached.

Highlighted

@Sergei Baklanthank you for pointing me in the right direction. I will learn how to use Power Query!