Help with vlookup
 

I am not sure if this is doable or not.

I have two workbooks, in cell H5 of the vacation workbook I wanted a formula
(vlookup?) which would look at cell A5 of the current workbook and then go
to the employee list workbook find the value I was looking for and return
the contents of the cell of column5 of the same row.

Example:

cell a5 of the vacation workbook = Jim

in the employee list workbook I want the formula to find Jim in column1
(which for this example is located in row 20, but of course could have been
in any row) and then return the value in cell E20.

Help with vlookup
 

=VLOOKUP(A5,[Book2]Sheet1!$A:$E,5,FALSE)

change the book and sheet names to suit.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Patrick Simonds" wrote in message
...
I am not sure if this is doable or not.

I have two workbooks, in cell H5 of the vacation workbook I wanted a
formula
(vlookup?) which would look at cell A5 of the current workbook and then go
to the employee list workbook find the value I was looking for and return
the contents of the cell of column5 of the same row.

Example:

cell a5 of the vacation workbook = Jim

in the employee list workbook I want the formula to find Jim in column1
(which for this example is located in row 20, but of course could have
been
in any row) and then return the value in cell E20.