Match Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill W - 18 Oct 2006 03:09 GMT

I am trying to use the Match function in a database to find b-50's in column
a. It does not find a match even though there is a cell that has that in it.
Is it because of the hypen?

Reply to this Message

JMB - 18 Oct 2006 03:17 GMT

Not because of the hyphen. Does your data have any trailing spaces?

> I am trying to use the Match function in a database to find b-50's in column
> a. It does not find a match even though there is a cell that has that in it.
> Is it because of the hypen?

Reply to this Message

Biff - 18 Oct 2006 03:21 GMT

You're looking for the TEXT string "b-50" or are you looking for the value
that is in CELL B50?

In either case post the formula you've tried.

Biff

>I am trying to use the Match function in a database to find b-50's in
>column
> a. It does not find a match even though there is a cell that has that in
> it.
> Is it because of the hypen?

Reply to this Message