match data by keyword

[jcaston85]

hi all i need a formula to match data in 2 columns that is not necessarily exact - therefore i'm thinking if i can identify field that have a common field i can see if the data within an index is a match. for example in the if i had a formula for the first cell (software warehouse) it would return logistic warehouse as a possible match ...


[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]SOFTWARE WAREHOUSE[/TD]
[TD]LOGISTIC WAREHOUSE [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CAT LOGISTICS [/TD]
[TD]CATERPILLAR TOOLS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]LONG ROAD BROTHERS[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]







the reason i cant have an exact match is i am potentially identifying results that may be slightly different titles however are essentially the same thing

i hope that makes sense

 

[PaddyD]

fuzzy string matching is hard, and more-or-less impossible with native formulas for anything even moderately complex.

see if this helps:

Alan's UDFs for the Fuzzy Match problem

post back if you can't get it sorted.