Information in Cells

[Jbb029]

What i am wanting to do is type in the employee number on my scheduel and once I am done it will enter the employees name. How is that accomplished?

[Special-K]

Enter a 2-column 3-row table of employees say in Sheet 2!A1:B3

123 Fred Bloggs
456 Joe Smith
789 Charlie Smithers

in Sheet1!A1 enter the employee number, e.g. 456
in B1
=VLOOKUP(A1,Sheet2!A$1:B$3,2,0)

Google VLOOKUP to find a description of how it works, basically it's
Lookup value
Table to lookup
column number to retrieve from the table
and 0 to match the lookup value exactly

[Jbb029]

Excellent I knew there was a simple way to accomplish it. It has been awhile since I have had to use VLOOKUP. Thanks