Hi everyone,

I've got two sheets containing data on the same group of people.
Data and Results.
The personnel info in Data is more complete than in Results
Data has Forename, Middle Name, Surname, DOB, Gender and most importantly an
unique Employee Ref.
Results contains Forename , Surname , DOB and Gender some, but not many Emp
Ref.
I would like to pull the Employee Ref from Data into results.

I think it's probably a case of doing Index Match on each set of data
because there will be mismatches due to differences in known by name and the
name held by records, people getting married and typing errors etc.

I haven't made a start yet but I'm planning to start by creating a helper
column with concatenated Surname, DOB and using Index Match and working from
there.

One problem I'm anticipating is if there are multiple matches and I am sure
there are more problems, so if anyone has any tips or helpful websites, I'd
be very grateful. I did find one website that gave a method for finding
matching text and a range of different formulas to find partially matching
text but can't find it now.

Many thanks
Diddy