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

3 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

  • Pricer187's avatar
    Pricer187
    Copper Contributor
    May 15, 2026

    Wasup I'm just trying to figure out how to get the most out of what these programs but it's hard for me due to the fact that I have been working with just a phone and don't much else to work with but I'm trying to see you have any advice that maybe could help or make it easier for me to use on the phone I'm trying to get something that would be helpful for me and whoever else but I feel embarrassed and frustrated but just wondering and run it by you thanks for your patience insight that you have provided it's very helpful have a good weekend