First of all hello everyone. I have been able to solve most issues I have by myself but this one is kicking my behind and such i am asking for help. I have seen similar posts but not exactly what i am looking for yet. I have figured out the drop down menus but for the life of me I cant make it display the results I want.
This is a different pill(caplet, capsule, ovals, tablet etc) selector that would display the results for a container size on a packaging machine.
Basically I have 1st drop down menu you can select the shape for the pill (lets say round). The second drop down would be for a specific round tablet (for now 10 different types. will grow as time progresses) Once the second selection is made i want the results for the specific tablet displayed in a set of cells.
The machine has 8 lanes and each can have the same pill or each can have a different one.
I hope i am making sense and apologize in advance. My skills with excel are absolute novice.