Forum Discussion
Solved
Double INDIRECT quandary - probably trying to do summat stoopid again...
Hi Everyone - thank you for looking at this question. I am trying to do something 'clever' - and appear to be missing the mark! I am using a dependent drop-down (using INDIRECT within Data Valid...
David-W196 As I see it, what you call the volatile dropdown list refers to a named formula FRU. List in data validation must refer to ranges, named or direct references.
Since you tagged your original post with Office365, why not look into the functions UNIQUE and FILTER as demonstrated in the attached file.
David-W196 Can you upload a file with the type of validations you are trying to implement? Remove any sensitive information, of course.
Riny_van_Eekelen - of course; I will create a basic file using the concepts - give me a short while; thank you.