rajesh nag
03-25-2008, 12:06 AM
Hi
I have values in two column
Case 1 Address and city
I would like to Know if city name exists in address coloumn
Ex h#52 jayanagar bangalore in adreess bangalore in city
I have two columns in company
I have to compare company in one column exists another company column or not, thing is i cann,t use vlookup as it looks for exact match i am looking for fuzzy match (80% match) or string match (any one word of this column exists in that column)
Ex: TSE company ltd in coloumn TSE com in another column
Can any one help me on this
Regards
Rajesh
I have values in two column
Case 1 Address and city
I would like to Know if city name exists in address coloumn
Ex h#52 jayanagar bangalore in adreess bangalore in city
I have two columns in company
I have to compare company in one column exists another company column or not, thing is i cann,t use vlookup as it looks for exact match i am looking for fuzzy match (80% match) or string match (any one word of this column exists in that column)
Ex: TSE company ltd in coloumn TSE com in another column
Can any one help me on this
Regards
Rajesh