P
Patrick Simonds
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.
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.