Data Validation Lists combined with VLookups

Hi everyone,
I am new to this forum so hello everyone.

I have a spreadsheet where I want to use dropdown lists that a dependent on each other. I have managed with the first part where I have my drop down list.

I need to now create another dropdown list in Sheet 1 column E but it needs to be based on the data in sheet 2 but also dependent on what is chosen in column D, so for example if they choose System Failings, column E contains a list:

Lack of quality evaluations/evidence/assessments
Coordination
Leadership
Funding
Partnerships (inter and intra sector)
VfM/efficiency
Connectedness/ humanitarian continuum
Changing humanitarian landscape and slow to adapt
Access

The above data comes from column F of Sheet 2.

Please HELP me solve my problem.

Hi Kevin,

Unfortuantely what I need to do is more complex that that link, as I use multiple words in the second dropdown which seem to cause problems.

Thank for trying though...appreciated.

That worked a tread, thanks for you help.