One try
In C1: =IF(COUNTIF(B1,"*"&A1&"*"),"Match","")
Copy C1 down. That should flag it as required provided the strings in col A
are as per your 1st example. Your 2nd example type doesn't look possible to
achieve.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"Karan" wrote:
My query is similar to Vlookup and as follows:
I have Data1 and Data2 both containing Complete Name of same individual or
person written in different format (like first name last name or last & first
Name or First name initials and Last Name & so on) in Coloum A and Coloum B.
I want to look up matching results of such names in Coloum C saying Match.
There is 25000 records and not possible manually.

Can someone suggest me that, is there any way i can sort out any 3 or 4
characters from each data. J Sridhar & Sridhar J Should be sorted out in same
row or can show in next coloum as match.

For Example
Data1(Col A) ATHESHAM
Data2(Col B) DR.ATHESHAM AHEMAD
Col C should Show Match (if not blank)

Data1(Col A) DASTHAGIR
Data2(Col B) D DASTAGIRI SAB
Col C should Show Match