Thread: Multiple Conditions on Data Validation

Hello All! Well... i'm stuck here =( I have a excel document where i need to have a cell dependent on two other cells... i've attached an example file to make it easier... but well I've already linked the cells "Brand" with "Topic" so depending on the user choice of brand he will get a specific topic list....

Now i need the cells Topic2 and Topic3 to be dependant on both Brand and Topic! For me the logic was: i'm going to name the range i want with a string (BrandXXXTopic) so i can acces it via data validation with a simple formula (=CONCATENATE(C2; "XXX"; F2)) But well... that just don't work =( How can i use the result of this formula to generate a data validation list?

For an example: If i Choose Brand1 and Soth America i should only be able to chose from Brasil, Chile, Peru or Agentina on the dropdown menu (BTW the field are all different... those countries are there just as placeholders so i can post the file here =D).

Thanks in advance! =D

Try renaming the range as:

Brand1_SouthAmerica

and then apply this formula in the data validation list option:

=INDIRECT(C2&"_"&F2)

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save