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

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.