software

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.
=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)

quot;Patrick Simondsquot; gt; wrote in message
...
gt; I am not sure if this is doable or not.
gt;
gt; I have two workbooks, in cell H5 of the vacation workbook I wanted a
formula
gt; (vlookup?) which would look at cell A5 of the current workbook and then go
gt; to the employee list workbook find the value I was looking for and return
gt; the contents of the cell of column5 of the same row.
gt;
gt; Example:
gt;
gt; cell a5 of the vacation workbook = Jim
gt;
gt; in the employee list workbook I want the formula to find Jim in column1
gt; (which for this example is located in row 20, but of course could have
been
gt; in any row) and then return the value in cell E20.
gt;
gt;