try this

put this formula in C2 and drag it down

=IF(ISNA(MATCH("*"&A2&"*",$B$2:$B$100,0)),"","matc h")




On Oct 24, 2:48*pm, Karan wrote:
Dear all,

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

I request you'll to help me to come out of this problem.

Thanks in advance.

Karan.