LinkBack URL
About LinkBacks
I have 3 dropdowns.
Codes, Groups, Materials
I have a table with data and I am trying to base the 3rd dropdown list on the selections of the first two.
See attached for clarification.
thanks!
I have 3 dropdowns.
Codes, Groups, Materials
I have a table with data and I am trying to base the 3rd dropdown list on the selections of the first two.
See attached for clarification.
thanks!
Hi Check it Out the attached file
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
D14 DV Custom Formula
=OFFSET(Table!$A$1,MATCH($D$12,Table!$E:$E,0)-1,5,LOOKUP(2,1/((Table!$A$1:$A$2823=D10)*(Table!$E$1:$E$2823=D12)),ROW(Table!$E$1:$E$2823))-MATCH($D$12,Table!$E:$E,0)+1)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Sixthsense, your code seems to match only drop down 2. For example, select 1ABA and Filter Media....you should only get 4 results. I really like your code because its one line.Originally Posted by :) Sixthsense :)
Thank you Naveed +rep
Sixth,
It actually shows the 4 its supposed to, but includes others...
dropdown.png
At present I am not in my system, will give you the solution by tomorrow since currently in 2007 version of excel.
Ok,
Naveed's suggestion works great. Would it change the approach if I needed to have multiple sets of dropdowns accessing this same data? With using data validation lists, i will have to duplicate lots of data. These 3 drop-downs will be duplicated several times on the same sheet so users can choose multiple chemicals.
Please check ROWS 83 to 86 data.
You should keep the sorted data to get the actual list.
Yes, rows 83 to 86 is the only data the dropdown should show if I choose 1ABA and Filter Media, however, it shows much more.
Then what about Row 12 to 15 Data?
Please keep unique data
Row 12 to 15 is for 1AAGThen what about Row 12 to 15 Data?
Please keep unique data
83 to 86 is for 1ABA
In E14 Cell
=SUMPRODUCT(--MATCH(1,(Table!$E$1:$E$2823=$D$12)*(Table!$A$1:$A$2823=$D$10),0)-1)
In D14 Cell Validation Formula
=OFFSET(Table!$A$1,E14,5,LOOKUP(2,1/((Table!$A$1:$A$2823=D10)*(Table!$E$1:$E$2823=D12)),ROW(Table!$E$1:$E$2823))-E14+1)
Refer the attached file
Refer the attached file
Awesome Sixth.....do you know why it brings in an extra?
extradropdown.png
Just remove the +1 from the suggested formula
=OFFSET(Table!$A$1,E14,5,LOOKUP(2,1/((Table!$A$1:$A$2823=D10)*(Table!$E$1:$E$2823=D12)),ROW(Table!$E$1:$E$2823))-E14+1)
I promise I tried that without luck. But today, it worksJust remove the +1 from the suggested formula
Again, appreciate your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks