Selecting rows that best fill a specified criteria

[CornFused9899]

I have a worksheet that lists necessary components to meet an objective and then several source inventories. I would like a way to pick the combination that best fits the needs and the combination with the fewest sources that meets the needs.

Needs Item 1 Item 2 Item 3 Item 4 Qtr 1 14 41 23 18 Sources Item 1 Item 2 Item 3 Item 4 JA1 19.6 14.7 4.9 2.5 BJR1 42.3 41.4 13.4 6.9 PRP11 2.6 1.3 1 0.48 CRSP 49.1 34.8 5.7 4 PRP9 20.4 17.8 4.9 2 BCN60 13.5 10.9 4.6 2.4 FRM1 19.3 18.3 1.6 0.57 PRP7 34.8 33.9 3.5 1.5 PRP-A 7.9 5.2 1.4 0.69 PRP6 4.4 5.1 1.5 0.69 BCN10 1.1 1 0.96 0.33 BCN9 2 1.8 1.1 0.28 BCN30 11.8 10.3 3.6 1.4 BCN08 1.8 1.4 1.1 0.33 PRP5 1.4 1.2 0.94 0.33 PRP-B 6.8 5.4 4.6 1.8 PRP-N 33 4.3 41 31 Best Fit Combination: Fewest sources Combination: <colgroup><col><col span="4"></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[alansidman]

IN your example, what would your expected results be?