Excel spread sheet Multiple look ups

C

Clay

I am trying to pull values from one field and asign them a code and then have
these values auto sum to assigned cells.
I am using a vlook up argument to take these values and place them on a
timesheet.

Now I am trying to take these individual codes and values totaled and placed
in a summary at the bottom of the sheet.
ie p = 7.6
N= 8
S= 7.6

Total Hours
Details Hours
N Normal 64
Annual
S Sick 7.6
Lieu
Public Holiday 7.6
Other
Total Hours 0
Any suggestions would be appreciated.

Clay
 

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

Similar Threads

Formula incomplete 2
Save Excel spread sheet 7
SUMPRODUCT with date range running slow 1
Time Sheet Summary 1
Weekly Time Sheet Summary 2
Weekly Time Sheet Consolidate 1
Single Weekly Time Sheet 0
Payroll 2

Top