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.