Compare part of cell contents with another column

[Hallett505]

Hi, I have spent a few hours trying to find a solution for this but feel the time is now right to ask for help!

I have a spreadsheet with address details in column A for around 100 of our company sites. In column B I have address details of all the properties our company visits, which includes company and non company owned sites, the address details are NOT exact matches. For example column a has 1 Smith St Adelaide but column b has U1 1 Smith Street Adelaide.

I can get good results for exact matches using =IF(ISERROR(MATCH(B1,A:A,0)),"False","True")
however, what I am struggling with is finding partial matches in the array A:A (ie where B1 is "U1 1 Smith Street Adelaide" return a partial match indicator to show that "1 Smith St Adelaide" is a value in A:A.


I hope this makes sense?


Hallett505

 

[PaddyD]

Hi - welcome to the board.

Fuzzy matching is hard, esp just using formulas. Try this and see how youget on:

https://www.mrexcel.com/forum/hall-fame-winners/69649-alans-udfs-fuzzy-match-problem.html

...post back if you need more.

 

[Hallett505]

Thanks, great tip, it all worked and returned the values I was looking for

 

[PaddyD]

Excellent