Hi, I am trying to use a wildcard in a formula but it is producing a result of ‘false’ instead of the answer. If i remove the wildcard the formula works fine. From what I have read it looks like the wildcard doesnt work with = in the formula but I dont know how to rewrite the formula not to include the equals sign, Can anyone help?
Thanks in advance, Stuart
By: Stuart Dudley