All,
Apologies, I'm sure the answer is here in the forum somewhere, and I have looked but can't find an answer which helps.
The issue:
Worktab 1
Worktab 2
I need to reference the 'Surname' in column C (worktab 2) against the names in column A of (worktab 1), and populate column C (in worktab1) with the correct company.
I hope this makes sense?
Thanks,
JC
Apologies, I'm sure the answer is here in the forum somewhere, and I have looked but can't find an answer which helps.
The issue:
Worktab 1
- I have a list of user names in column A (130 of them which contains both their first name and surname).
- I need to assign the company name for each user into column C which is currently blank.
Worktab 2
- Contains a list of 300+ users where their names are split into two columns (Column B = First Name, Column C = Surname), together with their relevant company name in column F.
I need to reference the 'Surname' in column C (worktab 2) against the names in column A of (worktab 1), and populate column C (in worktab1) with the correct company.
I hope this makes sense?
Thanks,
JC