Match Function

B

Bill W

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?
 
B

Biff

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
 
Top