In Column B, ICC would like to have the least costly amount. In Column C, ICC would like the name of the vendor, in order of preference, who is supplying the least expensive candy of that type. Column C will fill in automatically after you find the least costly option. Rich will explain how this magic works, but will not hold you to building it yourself. ICC would also like a heat map of the costs, by candy, to be set up on the Suppliers worksheet. Something such as the picture below: