Lookup and refrences - required solution as per attached file

hi
attached file "vehicle log" contain three sheet
HANDOVER LOG
DRIVER LIST
VEHICLE LIST

QUESTION 1
the answer should be in "HANDOVER LOG" sheet (i6)
"JAVED (E6)" has handed over the vehicle "JHK1234 (C6)" to MIKE (H6) At dated "08/16/14 (F6).
same vehicle "JHK1234 (C8)" has been handed over by MIKE (E8) to "POLL (H8)" at dated "8/28/14 (F8). the date of handed over "8/28/14 (F8)" the same vehicle shall be the same date of "DATE RETURN (i6). So how the answer formula shall be.
same shall be repeated for the rest of the handed over and return.



QUESTION 2
IN "DRIVER LIST"
Need answer in F4, G4, H4 lookup from the "HANDOVER LOG".

based on the "handover log" sheet "JAVED DRIVER (B4) take over the 2 vehicle.
answer shall be "Nos of vehicle 2", holding vehicle shall be "UAQ4321" and "JAK6565".

based on the "handover log" sheet "USAMAN DRIVER (B5) take over the ONE vehicle, and he return the same vehicle.
SO the answer is "ZERO" and vehicle no "no needed".


QUESTION 3
IN "VEHICLE LIST"
Need answer in COLUMN F (driver name) and columen G (handover date), Column H (ODOM)
the vehicle JHK1234 (C4), based on the "handover log" this vehicle "javed" give to "mike" and mike returned to "POLL" at dated 08/28/14. of ODOM 500. the answer is "driver POLL" , "dated 08/28/2014" and "ODOM 500"



i appriciate if you input formulas direct to the excel sheet.
regards