Hi,
I have two tables on the same spreadsheet - see attachment.
Both have 'Employee Number' within the table, only one table has 'NI Number'. How do I use a formula (I think a VLOOKUP) to transfer the NI Number from one table to sit against the correct Employee Number in the other table??
I'm really stuck with this and I have a HUGE list to apply this to!
Thanks for any help!!
Neil.
Bookmarks