Lookup() returning #NO MATCH when it is definitely there
I have created a new sheet to store the priority values of my ticketing system so if I change the values I don't need to change all the formulas on my main sheet. It's used to determine when to set the due date. It works fine for Low and normal, when I change the values it changes the due date correctly, but when I select "High" it says #NO MATCH. I have checked that there is no spaces at that they are both identical. I just can't see where I'm going wrong. Here's some screenshots
Any ideas would be really helpful.
Help Article Resources
Check out the Formula Handbook template!