I have a matrix table with a mixture of text High, Medium, Low, Event (see attached pic)
I want to write to a cell a word based on comparing two cells.
e.g.
If Cell A1 = Soon and Cell B1=4, I want it to show in Cell C3 = Medium
If Cell A1 = Automated and Cell B1=5, I want it to show in Cell C3 = High
I need to do this for 30 different checks based on the above. Basically comparing an urgency - cell A1, with a Consequence number (B1)
Any ideas how I best do this?
Bookmarks