Vlookup function

Hi hope you can help. I am creating a simple daily log for our controllers (cab office) , my aim is they select a office London Carriages or Paddington and a predefined list of drivers shows under drivers for that office (all works ok) then dependent on driver selected from filtered list the relevent details for that driver populate other cells ie Car Registration, Car Model.

This is where i got stuck and cant get it to populate. If you can help that would be really great . Thank you

Thanks for the really quick reply did you test it as i copied formula and get 0 value changed reference to C5 not G5 still no good changed to sheet1!C5 also still no good.

HI this works but for some reason now the select company list does not now display drivers. So how it should work select paddington and shows paddington drivers and polulates using your great look up function or if the select london carriages then displays london carriages drivers and on select driver shows details using your vlookup

Hi i really thank you for your great help and rest assured i will be giving you a great feedback. but on the sheet you sent everything works except lookup if you select padding ton driver.

If yoou select company paddington then you can choose paddington driver just how it should be but then select driver and the other vlookupdetails dontsho