excel - Partial, Exact match for two columns -


i've been looking everywhere , can't seem results want. haven't used excel in while , having trouble doing partial matches 2 columns. want find partial matches of column in column b , return position matches are. column contains data set of company names , column b contains set. want make sure abc llc comes partial abc inc.

is there formula that? want find partial anywhere in columns , multiple companies.

example:

 columna 1st choice staffing 84 lumber company accent hiring group accent hiring group accountants intl.
columnb: 1199seiu benefit , pension funds 171263 canada inc 1-800-flowers.com, inc. 1st franklin financial corporation 1st source bank

vlookup fantastic long looking exact matches. true / false argument doesn't serve purpose you'd thought serves. when you're looking things not black , white, you'd need fuzzy logic here.

a quick example of vlookup falls short :

  • song name = "beethoven : fidelio op.72"
  • song name b = "beethoven : fidelio opus 72"

microsoft released free add in excel (compatible recent versions) enables fuzzy vlook up'ing. file (add-in + documentation + example) here :

http://www.microsoft.com/en-us/download/details.aspx?id=15011

and pnuts's point, algorythm based on levenshtein distance.


Comments

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

c++ - qgraphicsview horizontal scrolling always has a vertical delta -