software

I have a different workbooks, the one workbook takes the output from
out employee time logging system and outputs in a format like this

All.xls
Name time in time out
ABC Robert L Jones 09:00 17:30
SDDF James Smith 09:05 17:20
etc...

The other workbooks are the managers ones that contain just the info
they need.

Manager1.xls
And then in the different manager's excel workbook we have it like
this:
Name time in time out
Bob Jones 09:00 17:30

Manager2.xls
Name time in time out
Jim Smith 09:00 17:30

I created a sheet quot;matchesquot; that matches the output from the system to
the manager's name like this:
System output Manager workbook
ABC Robert L Jones Bob Jones
SDDF James Smith Jim Smith

I would like to link the manager's work book to the all.xls workbook so
that I can automatically pull out the time in and time out stats from
the all.xls system output. I could do this using vlookup if the names
in the manager's workbook were the same in the all.xls but now have to
somehow do two lookups first in the quot;matchquot; sheet and then to pull up
from the all.xls worksheet.

How would I do a double vlookup.

A single lookup in the manager's workbook without referencing the name
matches would look something like this:
VLOOKUP($A2,'[All.xls]29'!$A$2:$C$84,2,FALSE) for the time in
VLOOKUP($A2,'[All.xls]29'!$A$2:$C$84,2,FALSE) for the time out
Where 29 is the name of the sheet (representing todays date)Is there an employee number for each staff??
You should just be able to replace the $A2 in this formula

VLOOKUP($A2,'[All.xls]29'!$A$2:$C$84,2,FALSE)

with your first VLOOKUP, e.g. something like

VLOOKUP(VLOOKUP($A2,namematchtable,2,0),'[All.xls]29'!$A$2:$C$84,2,FALSE)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=506158gt; wrote in message oups.com...
gt;I have a different workbooks, the one workbook takes the output from
gt; out employee time logging system and outputs in a format like this
gt;
gt; All.xls
gt; Name time in time out
gt; ABC Robert L Jones 09:00 17:30
gt; SDDF James Smith 09:05 17:20
gt; etc...
gt;
gt; The other workbooks are the managers ones that contain just the info
gt; they need.
gt;
gt; Manager1.xls
gt; And then in the different manager's excel workbook we have it like
gt; this:
gt; Name time in time out
gt; Bob Jones 09:00 17:30
gt;
gt; Manager2.xls
gt; Name time in time out
gt; Jim Smith 09:00 17:30
gt;
gt; I created a sheet quot;matchesquot; that matches the output from the system to
gt; the manager's name like this:
gt; System output Manager workbook
gt; ABC Robert L Jones Bob Jones
gt; SDDF James Smith Jim Smith
gt;
gt; I would like to link the manager's work book to the all.xls workbook so
gt; that I can automatically pull out the time in and time out stats from
gt; the all.xls system output. I could do this using vlookup if the names
gt; in the manager's workbook were the same in the all.xls but now have to
gt; somehow do two lookups first in the quot;matchquot; sheet and then to pull up
gt; from the all.xls worksheet.
gt;
gt; How would I do a double vlookup.
gt;
gt; A single lookup in the manager's workbook without referencing the name
gt; matches would look something like this:
gt; VLOOKUP($A2,'[All.xls]29'!$A$2:$C$84,2,FALSE) for the time in
gt; VLOOKUP($A2,'[All.xls]29'!$A$2:$C$84,2,FALSE) for the time out
gt; Where 29 is the name of the sheet (representing todays date)
gt;
Chip Pearson has a web page working with time sheet (time in and time out)
www.cpearson.com/excel/overtime.htm
Could it be of help?