On Thu, 6 Dec 2007 07:10:03 -0800 (PST), shelfish wrote:

istext didn't seem to work but I went back the the TRIM function
mentioned above and that seems to do it. I worked it into the MATCH
formula in column B.

That's not very helpful.

I don't know what "istext didn't seem to work" means.

Formula didn't calculate? If so, then you entered it as text and/or you have
calculations set to manual.

Formula returned an error message, rather than TRUE or FALSE? If so, what is
the error message?


--ron