Discussion Locked

Need to link Excel sprdshts w/ AutoFill

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a Employee Call-Off Log on "Sheet1" and the employee list on "Sheet2". The employee list includes EmployeeID(Column A), LastName(Column B) and FirstName (Column C).
I would like to be able to type the 4-digit EmployeeID # on the Log, and have the Last & First names autofill in the adjacent cells.
Can someone help? StevenFwx@Yahoo.com

From: stevenfwx@yahoo.com Date: 8/8/02

3 replies

by dklippert

You need the formula VLOOKUP
Develop a table (on a different worksheet, if you want) the first column will be the EmpID, the second - LastName, and the third - FirstName.
Highlight the table and in the address box type Employees and hit enter (This names the range. You can also use Insert>Name)

Back on the main worksheet in column B use the formula:

=VLOOKUP(A2,Employees,2,false)

In column C the formula will be:

=VLOOKUP(A2,Employees,3,false)

The EmpIDs should be sorted in ascending order.

This discussion is closed to new replies.