Dependent Table Analysis Problem

I am clueless as to even attempting this type of problem, but I am trying to figure out a way to automatically have excel to pick the appropriate group based on 1 or 2 options chosen. I work for a drug testing company and when the analysts are typing in patient data and choosing the different drugs that need to be tested for, I want excel to return in the appropriate cell the best drug panel or panels to run the patients on. For example:

__________Panel
_______1__2__3__4
Drug 1__X__X
Drug 2__X__X
Drug 3__X__X__X
Drug 4_____X__X
Drug 5_____X__X__X
Drug 6________X__X
Drug 7___________X
Drug 8___________X
Drug 9________x__X
Drug 10_______X__X


As you can see, Panel 1 processes 3 different drug types, whereas Panel 2 processes those same three drugs plus 2 others. Ideally if the analysts were to just choose drug 1 then the quickest panel to process would be panel 1 because it is shorter, hence requiring less time to run. However, usually 2 drugs are tested for. This is where my excel has lost me. If Drug 2 and Drug 5 were Chosen for a particular patient then ideally panel 2 would need to be ran because it kills two birds with one stone. But lets say that Drug 2 and Drug 8 were chosen, then I would need excel to return Panel 1 (which is shorter than Panel 2) and Panel 4. I have a userform setup that allows for up to two drugs to be chosen from drop down boxes, each using the same comprehensive drug list. If possible, I would like for excel to return the appropriate panel(s) in a box, possibly the list box, on the userform following the selection of the drug(s) to be tested for. If not, then is there some type of way for excel to analyze the table and spit out something that I could work with. I would greatly appreciate any help, It would be a life saver.

Is there an implicit assumption that the cost of a panel is linearly proportional to the number of drugs for which it tests?

Then one needs to know the run-time for each panel so there is an objective function to minimize.

Cost is a generic term.

Then lets say the runtime for each panel is (in seconds) 60, 90, 120, and 100 respectively. Just to clarify, if drug 1 is being tested for, then I have 3 options: panels 1, 2, and 3. After one of the 3 panels is chosen (preferably panel 1), then all of the drugs in that panel will be ran as well. Therefore, if panel 1 only runs 3 different drugs compared to the other two panels that run 5 and 6 drugs, then panel 1 would be the fastest due to having to run less. I'm sorry if I am not very helpful, I am still new to excel. Thank you for the replies though.

Why not just break down and post the whole thing?

Trust us to handle the complexity, because you aren't going to get far with this approach.

There's a lot of unexplained data on that sheet.

What is needed is your prior table that lists the drugs tested by each panel, and the cost (however you define that) of each panel.

See the workbook at https://app.box.com/s/gy7pd4uwer74935vyc2q

Sorry, no, not by me. Userforms are just a lot of niggling work.

I did add a comma-delimited list output, though. Same link.

You're welcome. Interesting problem.