E
Excel: Text (match, lookup...)
Hi, Please help?
I have two sheets, the one is an extract from Payroll about employee details
with first, second, third and lastname + initials.
The second sheet I have Firstname & Lastname columns and then a column with
the job title. I need to match the names and then pull the job decriptions
over to the first sheet with the many names and detail and need to match them?
Problem is that with the many names you still have surnames with 3 words and
to sort and filter that take weeks if sheet 1 has 17000 rows and sheet 2 have
2200 rows.
I have two sheets, the one is an extract from Payroll about employee details
with first, second, third and lastname + initials.
The second sheet I have Firstname & Lastname columns and then a column with
the job title. I need to match the names and then pull the job decriptions
over to the first sheet with the many names and detail and need to match them?
Problem is that with the many names you still have surnames with 3 words and
to sort and filter that take weeks if sheet 1 has 17000 rows and sheet 2 have
2200 rows.