Dependant Dropdown List

[-Paul-]

Hello All,

It's been a while since I've posted and was wondering if anyone could solve my problem please?


Here is my named range with the dropdown in cell K3

I then have a dependant list in L3



Here is the formula I have for the dependant list




Everything is working well. However, I want the dropdown range and dependant list to be in every cell in columns K&L. I can populate the named range into column K, but I'm struggling to populate column L. I've tried to follow a few online tutorials and use the Indirect function, but I'm missing something as I can't get it to work.



Any help would be greatly appreciated!

 

[Eric W]

You should be able to select the range L3:L9 (or whatever), click Data Validation, and enter the same formula you have showing, except remove the $ signs from $K$3.

 

[-Paul-]

Thank you very much Eric.
Working excatly how I want to it now.

 

[Eric W]

Glad to help. Thanks for the feedback.