Lookup words

  • Thread starter Thread starter NIkhil
  • Start date Start date
N

NIkhil

I have a list of names in a column and another in a second
column. I want to find out words from column 1 which have
a match in col. 2. The problem is the data entry has not
been done correctly. so if col A has a name given as
nikhil.s.k, col b might have it as nikhil.k or nikhil-s-k
or maybe nkhil.s.k

how do i work out on this?... need help pronto plz.

Regards

Nikhil
 
Hi
though not exactly what you're looking for, try the following (at least
the first 5 characters have to be identical to count as match)
Enter in C1 the following formula
=IF(COUNTIF($A$1:$A$1000,LEFT(B1,5) & "*")>0,"Match", "No Match")
and copy down

adapt the number of characters to match according to your requirements.
You may also use a combined formula which is first looking for an excat
match like the following:
=IF(COUNTIF($A$1:$A$1000,B1)>0,"Exact
match",IF(COUNTIF($A$1:$A$1000,LEFT(B1,5) & "*")>0,"Probably a match",
"No Match"))
 
Back
Top