Formula for Low, Medium, High Matrix

Hello, I am trying to create a formula that reflects a Low, Medium, High matrix and I'm having a harder time than I anticipated. I can't figure it out for the life of me. I feel like I'm on the wrong track...

I

J

K

1

List (Low, Medium, High)

List (Low, Medium, High)

=IF(I2=Low, AND(J2=Low), "Low), OR(I2=Low), AND(J2=Medium), "Low)

2

Low

Low

Low

3

Low

Medium

Low

4

Low

High

High

5

Medium

High

High

Image

Answer
Answer

I'd create the matrix on a worksheet, for example on Sheet2:

Image

Then, use a formula like this:

=INDEX(Sheet2!$C$3:$E$5,MATCH(I2,Sheet2!$B$3:$B$5,0),MATCH(J2,Sheet2!$C$2:$E$2,0))

Image

---
Best wishes, HansV
https://www.eileenslounge.com

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 22, 2025 Views 5,606 Applies to: