View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clay Clay is offline
external usenet poster
 
Posts: 29
Default Excel spread sheet Multiple look ups

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