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