Excel 2007 : VLOOKUP Function

[dcball12]

Hey there Excel Guru's,

I have two separate workbooks, one with a list of 1074 rows with an ID # First Name, Last Name (3 separate columns). On the other workbook I have a First Name, Last Name (2 separate columns). Using a function (I think vlookup would be best), I want to lookup on both workbooks the persons First Name and Last Name and grab the Employee ID from the one page and bring onto the other page.

Can anyone help?

[dcball12]

To give more information, Book 1:
Column J - First name
Column K - last name

Book 2:
Column A - ID
Column B - First
Column C - Last

Need to match First Name and Last Name for the sheets and add ID to those IDs

[dcball12]

Someone mentioned I need to make a Key on both sheets... anyone have any idea?

[dcball12]

nvm figured it out