I spent a lot of time trying to figure this out through multiple blogs and Googling so I thought I would share the solution and the equation I came up with. As you can see, I was trying to weight a numerical value and give it an importance of low, medium or high. You might be using this for a different reason such as if it’s a 1 give it a color of red or something of that sort you can modify this equation to your liking but if you have any questions please let me know
Here is the equation I used that if column F had a numerical value of 1 it would autofill column H with a description of low, medium or high based off of column F
=SUM(F55*(IF(H55=”High”,3,IF(H55=”Medium”,2,IF(H55=”Low”,1,0)))))
F55 is column F row 55, so on and so forth you get the picture if not leave a comment I’d be happy to assist.