hello group,

Excel vlookup works only if its an exact match,data i have is not in the
same format.For eg comparing John matthews & Mr. Matthews John.Thus there is
no way i can use vlookup as each time the format varies.Can any one suggest a
method to match these fields using some excel functions