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.