Hi Paul

You talk about Names in one part and employee numbers in the other.
Assuming we are talking about Names in both cases, and, assuming on Sheet1
you have names in column A, and Departments in column B, with a header in
row 1 and data starting in row 2.
Further, assuming on Sheet2, row 1 is header, the person's name is in column
A and you want to put the result in column D

On Sheet2 in Cell D2
=VLOOKUP(A2,Sheet1!$A$2:$A$1000,2,0)
copy down column D as far as required.

This assumes up to 999 rows of data. Change ranges and cell locations to suit.
If this doesn't work, post back with more detail of what each sheet looks
like, where you want the data captured etc.


Regards

Roger Govier


PaulGrowns1 wrote:
I have to workbooks, One workbook contains a list of personnel information
such as names and departments and the second has information regarding the
companies vehicle usage.

I wish to be able to link one cell/column in the second workbook to look
through the first workbook for the person's employee number and then place
his department into the cell.

If you need more clarification on this please email me at


Regards

Paul.