• 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!