Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple vlookup
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 "matches" 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 "match" 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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple vlookup
Is there an employee number for each staff??
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple vlookup
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: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=506158 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple vlookup
wrote in message
oups.com... 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 "matches" 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 "match" 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) Chip Pearson has a web page working with time sheet (time in and time out) http://www.cpearson.com/excel/overtime.htm Could it be of help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP - Multiple cells in lookup value | Excel Worksheet Functions | |||
Multiple if or multiple vlookup | Excel Worksheet Functions | |||
VLOOKUP and multiple columns | Excel Discussion (Misc queries) | |||
how do I use vlookup for multiple occurrences of the same value | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions |