Updating ID Number from Another Excel

[nymacaco]

Morning all,
Need some guidance or point me to the correct direction. I'm currently working on updating an employee database to migrate to a new system.
Currently I have two excel sheet with the following

First Sheet Has
First Name, Last Name with about 1400 records.

Second Sheet has
First Name, Last Name, PersonID with about 7000 records

The second sheet has a lot of garbage, however the PersonID info is correct but too many recorders that are no longer valid.
I need to take the 1st Excel sheet and add a column called PersonID and populate the PersonID using the data from the second excel sheet.
My only match field is First and Last Name.

I'm been searching around and reading forums, posts and so far I don't have any clear direction on where to go.

Please Help

[Kyle123]

Can't you just add an extra column with the first name and last name in on each sheet and then use a VLookup?

[nymacaco]

I was able to do it, thank you for reminding me of vlookup.

Here's the formula I used

=VLOOKUP(updateme!A2,ref!A2:B6729,2)

updateme being the first excel and ref being the second excel.


thanks!!!!