Which kook up function

[jun]

Hi:

I have excel sheet with ID NO., EMPL LAST, EMPL FIRST, TITLE, DEPART and TERMINATION DATE.

The spreadsheet is sorted by EMPL LAST. The ID NO is formatted as text (no number starts with "0'). There are common last names on the list however, ID NO. is unique but not sorted. What function is the best to apply if I am trying to fill up another spreadsheet with the following information using the ID NO.

Title, Department and Termination date

Please let me know the formula.
Thanks.
JR

 

[VoG]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html