Hi all,
Was recommended to visit by a colleague whom people here had previously helped somewhat massively, hoping you won't mind me asking for your assistance as well!
I'm almost certain that this is a really stupid, obvious thing I'm doing wrong, but despite a lot of Googling, different guides & searching these forums, I am still at something of a loss.
So, I've followed a few guides, including: this one.
Seems like its fairly easy right? Create a Row with Headers which forms the first Drop Down List, in this case, I have Headers from I1:P1.
Under each of these are a list of options relevant only to that Header, forming a range I2:P7.
What I Did:
Following the guides, I first applied my Drop Down in B5, reading I1:P1 (this, despite my obvious Excel deficiencies, works fine, as have many before it).
Then, I selected the range, including the Headers, I1:P7 & used Formulas > Create from Selection, using only the "Top Row" Check Box.
Following that, I create a new Drop Down List with Data Validation in cell B22, using the formula:
Errors & Problems:
However, at this point I get the message:
Which, presumably, is my big red flag, because if you try to proceed, the Dependent Drop Down Box offers you a Drop Down Arrow, but nothing more. No options at all.
Like I said, I'm certain that it's a classic case of user error on my part, but I've tried removing the spaces in my range (which is what I had been led to believe the "substitute" portion of my formula was to account for) & a couple of other things I could think of. Unfortunately, this is beyond my limited Excel skill set.
If you are able to help, thanks in advance, & if not, thanks for looking
Was recommended to visit by a colleague whom people here had previously helped somewhat massively, hoping you won't mind me asking for your assistance as well!
I'm almost certain that this is a really stupid, obvious thing I'm doing wrong, but despite a lot of Googling, different guides & searching these forums, I am still at something of a loss.
So, I've followed a few guides, including: this one.
Seems like its fairly easy right? Create a Row with Headers which forms the first Drop Down List, in this case, I have Headers from I1:P1.
Under each of these are a list of options relevant only to that Header, forming a range I2:P7.
What I Did:
Following the guides, I first applied my Drop Down in B5, reading I1:P1 (this, despite my obvious Excel deficiencies, works fine, as have many before it).
Then, I selected the range, including the Headers, I1:P7 & used Formulas > Create from Selection, using only the "Top Row" Check Box.
Following that, I create a new Drop Down List with Data Validation in cell B22, using the formula:
Code:
=INDIRECT(SUBSTITUTE(B5," ","_"))Errors & Problems:
However, at this point I get the message:
Which, presumably, is my big red flag, because if you try to proceed, the Dependent Drop Down Box offers you a Drop Down Arrow, but nothing more. No options at all.
Like I said, I'm certain that it's a classic case of user error on my part, but I've tried removing the spaces in my range (which is what I had been led to believe the "substitute" portion of my formula was to account for) & a couple of other things I could think of. Unfortunately, this is beyond my limited Excel skill set.
If you are able to help, thanks in advance, & if not, thanks for looking
