Finding Possible Matches to a Solution

Hi, this is a good question. I’ve run into something similar when working with data in Excel. If you want to avoid VBA or macros, try the Solver add-in. You can set your target cell to match column C and let Solver decide which items from column A to include. It will return one valid combination, and you can re-run it with different starting points to get alternatives. For quick checks, you can also use SUMPRODUCT or logical formulas to test candidate sets. If you are working with larger data, Power Query is useful for reshaping before applying conditions.