Forum Discussion

sethubalaji's avatar
sethubalaji
Copper Contributor
May 15, 2026

Excel Functions

Find attached a matrix, and picture below

I select Rare (0.5) in a cell and Modera (8) in another cell, i want function to return in a cell from matrix above. Like A (4) with green filled in. My inputs are Rare (0.5) and Moderate (8) and i want output cell to be Green filled in A (0.5) picked from matrix above. Like wise if the input cells are Possible (2) and Critical (50) then the output will be D (100) filled with light orange. I tried Index and Match function but failed.

I can send the excel if you want.

Please let me know what is the right function i have to use. Send the solution to mailto:email address removed for privacy reasons or email address removed for privacy reasons

 

Regards

excel
Excel on Mac

2 Replies

  • IlirU's avatar
    IlirU
    Iron Contributor
    May 16, 2026

    sethubalaji​,

    In cell A13 try below formula:

    =TOCOL(IF((A3:A7 = A11) * (A12 = C1:G1), C3:G7, NA()), 3)

    Hope this helps.

    IlirU