Data Validation

Hi

I have a report that I email to a number of different people in different businesses, I have used Data Validation to set up a range of different search lists/menu's but some of the users cant use one of the drop down lists but can use the others. I am wondering if this is because in this particular data validation there is a really big formula to select the correct list to display? I am thinking that the working data validation lists don't have a formula at all in them. Some of the user can open all the data validation list no problems so I am assuming that is due to different versions of Office.

Any help and direction would be appreciated.

Thanks

This is the formula I have used

=IF($G$7&$D$7='a ref'!$H$1&'a ref'!$H$2,DMSS,IF($G$7&$D$7='a ref'!$H$1&'a ref'!$I$2,DMSA,IF($G$7&$D$7='a ref'!$H$1&'a ref'!$J$2,DMSB,IF($G$7&$D$7='a ref'!$L$1&'a ref'!$L$2,ESSS,IF($G$7&$D$7='a ref'!$L$1&'a ref'!$M$2,ESSA,ESSB)))))

Originally Posted by humdingaling

the nested if's dont look like anything wrong with them

assuming those True statements are named ranges
anything special about them?

Yes they are name ranges. The name ranges pull from different lists of cell which have array formulas in them.

Originally Posted by FDibbins

Formula looks ok. I would probably have put those combo's in their own cell to simplify the formula, but no biggie. What do you get when you copy that DV formula to a cell in the worksheet?

I get a result of one of the names in the name range, the second top name.

Originally Posted by FDibbins

OK and was that a result that should have been expected?

The list has 5 names in it an it pickup up the second name, I'm not sure why it picked up the second in the list and not the first?

Originally Posted by humdingaling

i count 6 names in your formula?

Yes there are 6 different names in the formula, what I mean is where these names refer to, the one that was selected by the formula refers to a list of 5 names and it picked the second of that 5. hope this makes sense cause im not using the right technical terms.