Formula based on two column values

Cathy Fraser

Hi, I am looking at doing a formula that looks at two columns and provides a # value based on what on the values that are in the two columns

This is a simple formula that I am looking at, but it will only go two levels down and then stops.

=IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 1, "1", IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 2, "2", IF([Urgency Rating]@row = 2, IF([Importance Rating]@row = 1, "3", IF([Urgency Rating]@row = 3, IF([Importance Rating]@row = 1, "4", IF([Urgency Rating]@row = 2, IF([Importance Rating]@row = 2, "5", IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 3, "6", IF([Urgency Rating]@row = 2, IF([Importance Rating]@row = 3, "7", IF([Urgency Rating]@row = 3, IF([Importance Rating]@row = 2, "8", IF([Urgency Rating]@row = 3, IF([Importance Rating]@row = 3, "9"))))))))))))))))))

Not sure what I am doing wrong?

I really appreciate any help you can provide.

Cathy Fraser

All good, worked it out went with Index and collect and used a help sheet

=INDEX(COLLECT({Priority Scale Master Range 1}, {Priority Scale Master Range 2}, [Urgency Rating]@row, {Priority Scale Master Range 3}, [Importance Rating]@row), 1)

Thought I would add the outcome, just incase it helps anyone else :-)

Genevieve P.

Hey @Cathy Fraser

I'm glad you figured it out! Thanks for posting your solution 🙂