List drop down and dependent drop down

[marimuthuravi]

Hi

I have 2 worksheets in my excel workbook(attached sample). In Sheet 1 i have 3 columns Item #,Stage & Deliverable Type .
What i need is below

In Column B of Sheet 1 , i want to have a list drop down from Col A of Sheet 2
In Column C of Sheet 1 , i want to have a list drop down populated based on value selected in Col A of Sheet 1
for example if i select ASK in Column B of Sheet 1 , Column C should show below drop down list to select the values

0.1 Business Value
0.2 User Journey(s)
0.3 Business Flow Diagram
0.4 System Map


Can some one help?

Regards
Ravi

[Pepe Le Mokko]

https://www.contextures.com/xldataval02.html