Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup on worksheet
I am building a workbook that has one "master" worksheet. This shows total
hours for various employees, and the first column will be their employee number. I will then have individual worksheets for each employee. The worksheet name will be their employee number, and each person goes into his/her own sheet to update their hours worked by each day, which will then be totaled for the entire month. I want the main worksheet to lookup the total hours for each employee, based on what is on their individual worksheet. Can I set up VLOOKUP (or another function) to accomplish this? The sheet name used in the VLOOKUP formula would have to be each persons' employee number. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup on worksheet
You could use INDIRECT
In your master sheet, Assuming the employee nums (indiv. sheetnames) are listed in B1 across you could use this in B2: =VLOOKUP($A2,INDIRECT("'"&B$1&"'!A:B"),2,0) with B2 then copied across/filled down as required -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:370 Subscribers:68 xdemechanik --- "richzip" wrote: I am building a workbook that has one "master" worksheet. This shows total hours for various employees, and the first column will be their employee number. I will then have individual worksheets for each employee. The worksheet name will be their employee number, and each person goes into his/her own sheet to update their hours worked by each day, which will then be totaled for the entire month. I want the main worksheet to lookup the total hours for each employee, based on what is on their individual worksheet. Can I set up VLOOKUP (or another function) to accomplish this? The sheet name used in the VLOOKUP formula would have to be each persons' employee number. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup on worksheet | Excel Discussion (Misc queries) | |||
How do I lookup a worksheet name in excel? | Excel Worksheet Functions | |||
lookup for worksheet | Excel Worksheet Functions | |||
multiple worksheet lookup? | Excel Discussion (Misc queries) | |||
Worksheet lookup | Excel Discussion (Misc queries) |