Hello there,
I have attached a sheet which contains benefits with one or two criteria
Although the formula in range E8:E16 does work, I feel the formula C8:C16 maybe better (able to be shortened (instead of having a separate formula for all the criteria 1-9 within each cell of the range C8:C16) for each number (between 1-9) with index/match (as there is multiple criteria) involved
Currently the numbers (1-9) are allocated to their own separate cells
Thank you for the assistance