Dynamic Data Validation

Hi All,

I would like to create a dynamic Data Validation list in 'Service Costs' Sheet in cells B2 C2 & D2 - All to have a 'Parent child' relationship - So when for example 106 is selected in B2 the only engine options that come up in C2 are;

1.5 D
1.1 Petrol
1.4 Petrol
1.6 Petrol
1.5 D
1.1 Petrol
1.4 Petrol
1.6 Petrol

and depending on which one of these you select in C2 it will determined what will appear in D2 options.

Sorry to ask but I have read 20+ topics on this now and watched countless youtube videos but cant get it to work!!

Thanks for the prompt reply, yes I found that one and watched the video but cant get any of it to work for me in this application.