Lookup Problem (I think)

  • Thread starter Thread starter seftonbarn
  • Start date Start date
S

seftonbarn

My workbook has a worksheet for each of 8 members of staff. Eac
Worksheet has 4 columns, each with three rows beneath. At the head o
each column is entered a job number (row 1). Employers may work on u
to four jobs at a time. And any of the 8 employers may be involved i
an other job. Underneath the job number the employer is required t
enter their time details. The first row (Row 2) is Travelling Time
the second (Row 3) is time on that job. Row 4 is just a total of the
above it.

I need a function that will lookup all of the worksheets for a jo
number and return the total of hours work on that job, irresepective o
how many employers have worked on it
 
I tried that using this formula =HLOOKUP(O28,'Repairer
1'!C27:F28,2,FALSE) where O28 is the Job Number on the Summary Sheet
and for "Repairer 1" C27:F27 is the Job Numbers and C28:F28 are the
hours worked for each Job. I intended to add this formula for the
other 7 repairers but it didn't even work on the first. It returns
#N/A. Help
 
Back
Top