Hello!
I've been looking for this fature quite a long time and i found this article:
"How to create multiple dependent drop-downs using array formulas in Excel?"
BUT.... The solution doesn't work and the author doesn't respond
Can anyone please help?
I share the sample file here.
Thank you!
Last edited by manteigas; 08-07-2021 at 04:09 AM. Reason: File update
Is your profile up-to-date? Are you still using Excel 2007?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
if you do not find a solution using formula, consider using VBA
far cleaner than littering your worksheets with formula.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
Thank you for your comment. Just update it!Originally Posted by AliGW
That does it perfectly.
But i'm sure a formula solution exists and that's what i'm looking for.
I sincerely thank you for your reply. Pretty sure it will help many as well.
Thank You!
I believe that there are two issues.
1. The article didn't include the equal sign in front of the formula for the source of the data validation
2. The double quotes used in the article do not copy correctly
I have corrected for the Laptop column on the temp sheet and the data validation source formula for cell A16 on the SampleData sheet.
If you have further problems with the the instructions in the article let us know.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks