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!
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!