Excel question with functions/macros?

Hi i'm new to excel,

i'm not sure whether or not this is possible to be done just by functions alone or if this does require a macro.

I'm trying to reduce the amount of errors possible in my list, each row has 4 columns, ID,Last Name, First Name, and Data on that person. If its possible i would to just type in the ID in the first column and then have excel input the Last Name and First Name if that ID. This wau i don't end up getting typos in the Last and First name, this would also help me to see if I type in the wrong ID a different name should appear. I have a feeling that this would probably have to be done by macro, but i'm not familiar with VB, so i was hoping there might be a way to do it with regular functions.

Thanks

i'm sorry i forgot to say, that yes i would have another worksheet that has all the listed ID, Last Name, First Name in seperate columns