Help! Probably dumb newbie question but need help with if/then??

[excel-idiot]

Thanks in advance to anyone that can help. I have looked through many other
posts and don't quite think I am asking the right search questions. Here goes:

Lets say I am creating a schedule and when I type in an employee number in
A1 how do I get excel to then enter data that I specify (name, skills,
whatever) in subsequent cells (b2, b3, etc)???

 

[Ragdyer]

Vlookup should do what you want.

Check out this web page of Debra Dalgleish on the function:

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