Is it possible to conditionally use multiple named ranges in a cell?

[Ryan Hungerpiller]

I want to use either Range A or Range B based on the value in the cell next to it, for example if the cell next to it is 'debt' then I want to use the named range Debt (Credit, Debit, Cash) else use named range Credit (Savings, Checking, Cash) in the dropdown for the cell. I used an if formula and it looks like the formula almost works but then get a #value error.

Any help greatly appreciated. Thanks.

[#2]

Hi Ryan

Yes it is possible,  I've written a blog post on it 

https://accessanalytic.com.au/excel-dependent-drop-down-boxes/

[#3]

Thanks I will test it tonight