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

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)???

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

Vlookup should do what you want.

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

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"excel-idiot" wrote in message
...
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)???