Lookup on worksheet

R

richzip

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
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top