Hi everyone,
Appreciate if anyone could help me with this. I'm stuck at this for days now.
My final goal is to get the INDIRECT formula working so I can setup DATA VALIDATION (list) with it. I want to have a dependent drop down list which leaves out blanks and sort the items in drop down list alphabetically.
I am trying to get INDIRECT to work with my formula.
Let's say in cell A1, I have a set of formula which results in the following text:
Notice that the range above is dynamic depending on what input I key into my first drop down list.
Now, in other cell, I put in the following:
This is the code that I would ultimately use to put in my second (dependent) drop down.
Is there other way to make it work? Thank you in advance
Bookmarks