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

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