ExcelBanter - Match Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Match Function (https://www.excelbanter.com/excel-worksheet-functions/114883-match-function.html)

Bill W

Match Function

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?

JMB

Match Function

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

"Bill W" wrote:

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?

Biff

Match Function

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

"Bill W" wrote in message
...
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?

All times are GMT +1. The time now is 02:32 PM.