Data validation with row and Column condition

[drom]

Hi and Thanks in advance!

I am trying to apply a data validation

• rcCountries is a dinamic list coming from a table column where I can chose different countries
• If Column D is >< than blank and Row 7 is equal to blank use rcCountries

I could use 2 different formulas to my data validation

• =IF(OR(E$7<>"";$D14="");"";rcCountries)
• =IF(E$7<>"";"";IF($D14="";"";rcCountries))

But I get the following error:

• The List source must be a delimeted list, or a reference to a single row or column

Can I avoid this problem in a datavalidation ??

 

[Cubist]

Try putting rcCountries in INDIRECT().