Partial Address match in an array
 

Hello i am working to compare 2 lists of addresses... I have taken both
lists and tried to get them down to the lowest common info (replacing
Road with Rd and such) but i am still having trouble getting many
matches.

I was thinking that if I could use Index(,match( with the search
function in here that would allow to match the text inside but i am
unsure if 1 this is possible and 2 how to use the search function in
this manner.

Any help would be greatly appreciated.

Thanks

Chuck