assume you put the employee name in Cell A1 of TimeCard

in B1
=if(iserror(match(A1,Employee_Name,0)),"",Index(Em ployeeID,match(A1,Employee
_Name,0),1)

this assume you have defined names for the ID (EmployeeID) and Name
(Employee_Name).

Insert=Name=Define

You would need to do that for the names to use a data=validation dropdown.

--
Regards,
Tom Ogilvy

"matlocktm" wrote in message
om...
What I'd like to accomplish is difficult to explain, as I am an Excel
novice, but here goes: I am creating a timecard using a worksheet
(labeled "timecard"), and on a second worksheet (labeled "employee
data") I've created a simple table consisting of two columns, one
labeled "employee name" and the other labeled "employee ID", for which
I am using to reference. I created a drop-down list of employee names
on the first worksheet that references the "employee name" data from
the second worksheet. Here's where I am at a loss: In a cell on the
first worksheet, I'd like to have the "employee ID" automatically fill
in based on which "employee name" is selected from the drop-down list.
Does anyone know how to accomplish this? I assume the "employee name"
and "employee ID" on the second worksheet need to reference each other
somehow, but I am unsure of this. Any help is extremely appreciated.
Thanks.