I had the same problem, but only in worksheets where the values I was trying to match against were numeric values. I changed the format from "General" to "Text" for the entire worksheet, but that didn't do the trick. Then I changed all the numeric values to words, and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.