Hello,

I have an Excel to track performance. Sheet1 is performance table where user
input their ID, date, part#, side, start seq & stop seq daily. Then
on a reference sheet called "Ref" with field: part#, side, seq#, time(min).

I need a formula to put in the column G in sheet1 to calculate the time
based on a match of part#, side, start seq and stop seq of "Ref" sheet.
Thanks

Example:
Sheet1 - User input data
A B C D E F G
ID date part# side start seq stop seq Calculated Time
001 1/8/08 1360-1 1st 100 400 55 (5+10+10+30)
002 1/10/08 1360-1 1st 300 500 65 (10+30+25)

Sheet2 - Reference
part# side start seq time (min)
1360-1 1st 100 5
1360-1 1st 200 10
1360-1 1st 300 10
1360-1 1st 400 30
1360-1 1st 500 25
1360-1 1st 600 60
1560-3 2nd 100 10
...........