For every day I keep records of machine down-time for 20 machines
on worksheet: "downtime history"

A B C
D
date mach.no. down-time day-shift down-time night-shift
07-10-08 12 03:00 06:00
07-10-08 13 00:00 01:10
07-10-08 14 02:20 00:10
and so on.....


On my analysis sheet "efficiencies" I can change the date in cell: B3
in L3:L26 I have the machine numbers. In M3:M26 I need the downtime
for each machine for the date in B3.

Is that possible to lookup in the database I keep on sheet: "downtime
history"?

To be answered:
What was the <downtime day-shift for machine 12 on the date in B3?
I basically have to lookup 2 values; the date and the machine and that
is where my problem is.

Thanks.