Thread: 3 way lookup

hi
i have 2 excel sheets
1 ) contains dates and timing of staff working in shifts
example
1-1- 2011 from6:00 am to 8:00 am walter 'shift driving volvo s80
1-1-2011 from 8:30 to 10:00 henry shift driving volvo s80
1-1-2011 from 9:00 to 10:00 John driving GMC van
1-1-2011 from 12:00 pm to 1:pm john driving Volvo S80

and list goes on for 500 delivery drivers with vehicles

2nd sheet
I have list of overspeeding reports of the vehicles m whiuch shows like
this

1-1-2011 8:45 am Volvo S80 , overspeeded by 70 miles
1-1-2011 12:30 pm volvoi S80 , overpseeded by 100 miles


against each of this overpeeding , i need to match the person who was driving the Vehicle at this particular time
infact i am looking for 3 way look up , Date , time and Vehicle lookup to give the result of the driver

i tired with Sumproduct , but i didnt get the results

i hope somebody can help me with this

Thanks
Kevin

Do we have a file to refer to so that we can come up with some solution?