Formula based on two column values
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.
Answers

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 :)

Hey @Cathy Fraser
I'm glad you figured it out! Thanks for posting your solution 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!