For a better experience, please enable JavaScript in your browser before proceeding.

Im using indirects in data validation to call up the correct range.

For some reason it isnt working even though Ive done it hundreds of times before on a PC.

My dynamic ranges are actually named IncomeGroups and ExpenditureGroups so I am concatenating the indirect in the data validation box.

Renaming the ranges to match exactly with the format in Column D is making no difference so I dont think the concatenation is causing the issue.

So in my data validation, assuming I am currently setting validation rules for cell E5 Ive input List Source INDIRECT(D5GROUPS) and it unfortunately isnt working.

The dynamic ranges are working fine elsewhere when I directly reference the range (i.e.

I were to just write IncomeGroups in the Source box within data validation, it works fine).

If you have just two options, try the following instead: CHOOSE(MATCH(D5,List,0), IncomeGroups, ExpenditureGroups) where List is a range consisting of subgroup names.

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

Excel For Mac Data Validation