Wow that table does exactly what I was wanting it to do. Thank you so much for your help! Sorry I didn't understand the cost concept, my understanding of Excel is basic. This table will really come in handy at our company. I wonder, though, if there is a way to tie this chart in with the userform that I built on the 'Repeat Data' tab? Would it be possible to have it autofill the box labeled "optimal panel" after selecting the analytes (drugs) from the drop boxes in the userform. If only one panel is needed then return that panel or return multiple panels if need, possibly separated with a comma. Thank you.