Automatically Fill Adjacent Cells Based On Input Data

Hello,
I am using Excel as a continuous sign in sheet at a recreation facility for kids. I'd love to find a way to have it so that when our front desk person inputs a student's ID number into one column, their corresponding first and last name populate in the two adjacent cells in the same row. Is there a way, somewhat similar to having a column for validation, to make these automatically fill in if we input that validation data?
The main issue of course is that we are having issues when we want to count how many times an individual has used our facility for our data and records. If their names are spelled differently when signing them in at any time, they will count as two separate visitors.
Thanks much!

This is possible. How are you keeping the data that contains the names and ID numbers? If it's on a separate sheet, you can just do a vlookup.

If you could, post up a sample workbook (make up random names and ID's in the form of your current sheet).