Data Validation Issue

I have a named range I am using that is a reference to two different columns of data. If I was to use data validation on a cell, with only the named range, it works fine. But i have expanded the formula in the data validation to include =if(counta(cell1, cell2)=2, namedrange) to prevent user from accessing the drop down list unless there is data in cell1 and cell2. As soon as I add the additional verbage, it throws me the "The List Source Must Be A Delimited List, Or A Reference To A Named Row Or Column". It's interesting because I have a sister project that is using virtually the exact same sheets/data, and i have had no issues using this validation method.

I am really confused.

Thoughts?

Thanks in advance.

This is working for me when I select Data Validation-->List and enter the formula you gave. Can you upload the sample book that you are doing the validation so that I can check where exactly its going wrong?

Validation Test File.xls

If you open the "Friday" sheet, and validate cell L10 with =if(counta(E10, I10)=2, List_EmpMgtBox), then you should see the message. If you just validate with =list_empmgtbox, then it works, but it doesn't do what I need.

Thanks for taking a look.

Same. Its working for me.

Crazy. I copied your validation into my master file, and it took. I wrote the validation for the cell beneath it, and it didn't work.

Call it solved, and I won't ask why.

Thanks for your assistance.

I have a favor to ask.

Can you do the same thing to the file you sent me, but do one cell =if(counta(E10, I10)=2, List_EmpMgtUsh), another cell =if(counta(E10, I10)=2, List_EmpMgtCon), and another cell =if(counta(E10, I10)=2, List_ActiveMgt)?

It won't even let me change the validation i copied from your file.... /sigh

haha, truly crazy.