Excel Functions | Microsoft Community Hub
sethubalaji
·
2026-05-15
·
via rss.livelink.threads-in-node
Forum Discussion
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
sethubalaji,
In cell A13 try below formula:
=TOCOL(IF((A3:A7 = A11) * (A12 = C1:G1), C3:G7, NA()), 3)
Hope this helps.
IlirU
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
=INDEX(data,XMATCH(rh,rowheaders),XMATCH(ch,columnheaders))
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。
