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
Bookmarks