INDIRECT when reference another list - error

What is in D5 ?
I presume it's the name of your named range..

So next question, how is that named range defined? Can you post the contents of the 'Refers To' Box for that named range?

OK, the problem is that you can't use dynamic named ranges in this setup with indirect in the validation.

Each category must be a hard coded named range.

Thanks a lot, that worked.

2 follow up questions:
Can I make my list some how dynamic?

and, I'm I able to use "=INDIRECT("RC[-1]",0)" to refer the left cell?
With "=INDIRECT($D$5)" I need to go in and change it for every cell and that takes a lot

This doesn't work
=INDIRECT("RC[-1]",0)
Because Indirect reads a TEXT string and turns it into a Cell Reference.
Slo "RC[-1]" IS just a Text string, and it ends returning the cell reference to D5.
so it ends up returning the contents of D5

This works
=INDIRECT($D5)
Because $D5 is NOT a Text string, It's a cell reference, so it reads the Text string from within D5 "Food" or whatever, and then converts that to a range reference.

Hello Jonmo1

D5 is where I pick the category regarding my expense, so thats where the other cell should take it information to know which list it should use next.

This is my name range:

=OFFSET(ManagementSheet!$B$2,0,0,COUNTA(ManagementSheet!$B:$B),1)

This is how I have done with all the name range categories, changing the column letter

OK, I see you attached a book.

Which cell did you enter the validation of =INDIRECT($D$5) ?

Try
=INDIRECT($D5)

Great! Thank you very much for taking the time to explain everything rather then just giving me the answers =)

You're welcome.