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
Post a Comment