Dear experts,
I need your assistance to check on my formula for match.
I am not sure why the formula doesn't work.
Please refer to the attached excel, whereby i have worked the formula.
What i wish to achieve as per below:
If i select frequency "1" and the impact "1", the individual risk should show me "Low"
You can refer to the matching formula on "Risk Matrix Tab".
Thank you in advance.
Regards,
Steve
Try
Formula:
Please Login or Register to view this content.
Please try
=INDEX('Risk Matrix'!$C$15:$G$19,MATCH(B4,'Risk Matrix'!$B$15:$B$19,0),MATCH(C4,'Risk Matrix'!$C$20:$G$20))
or
=INDEX('Risk Matrix'!$C$15:$G$19,6-B4,C4)
or
=VLOOKUP(B4,'Risk Matrix'!$B$15:$G$19,C4+1,0)
Great works very well. Thank you so much. Appreciate it very much
Thank you, it works well now.
Administrative Note:
1. Thread titles need to be specific, not generic - just telling us the functions you are using is not enough.
2. Please mark your threads as solved - select Thread Tools from the menu link above and mark this thread as SOLVED.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Actually, im struggling to explain that. My apologies
No, you aren't. The third paragraph of your opening post could have been used for your title.
Please make more of an effort next time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks