How can I link one cell to a list of info in another workbook?

[Guest]

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
(e-mail address removed)

Regards

Paul.

 

[Roger Govier]

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

 

[Guest]

Roger thanks,

Sorry for any confusion. On worksheet one I have the following, Column a is
rank, column b is employee number column c is name and column d is dept.

On the second worksheet i have vehicle usage, so column a is the vehicle
reg, column b the miles travelled and column c is the drivers employee number

 

[Roger Govier]

Hi Paul

Try entering in D2 of Worksheet 2
=VLOOKUP(C2,[Filename.xls]Sheet1!$B$2:$D$1000,3,0)

Substitute your actual filename and sheet name.

Regards

Roger Govier