how to create dependent dropdown list in Excel

[m_vishal_c]

Hi,
i need to create dynamic dependant dropdown list in excel like below

Unique Aged Care Name	Aged Care Name	Doctor Name
A	B	John
B	B	william
C	A	Peter
D

Unique Aged Care Name is all Aged Care Names, Aged Care Name is dropdown to select Aged care.

I need dependant dropdown list like if I select B as Aged Care Name then "John", and "William" should come to another column

I just need to create in Excel not macro

Heaps thanks

 

[Toadstool]

I'm not following. Can you share the Named Range contents and confirm which columns are used?