Look up table
Recently I encountered a very strange and persisting problem in SmartSheet which I couldn't find a solution for. I wonder if someone can help me here.
I created a lookup table which intends to grab a number, e.g. a hourly fee from a the table an use it in another location (another row, another column, even another sheet; I tested all). I listed different roles like Engineer, Director, worker, etc. each of them has fee. The formula works for all entries, except director. When the search value is "Director", the result is "#No match" but when the entry is any other value, like "Engineer", is gives me the correct result.
If I change the item to "MDirector" it is working, but if I change it to "DDirector" it is not. It means the word "Director" is not a problem, probably. I'm really confused. Does anyone have any opinion?
Help Article Resources
Check out the Formula Handbook template!