I'm using three seperate Match functions to find three items in Column A to
get the row they are on.
The first match is returning the right row number, 10. =MATCH("Ben
Franklin",A:A)
However, the second and third are not:
=MATCH("OHAC",A:A,1) returns 24 but is on row 36
=MATCH("Mister Sparky",A:A) returns 21 but is on row 50
I need the OHAC to return 36 and Mister Sparky to return 50

All three match functions are in column J
They all refer to range A:A.
Any help would be appreciated!

If you're matching on Text values, I bet you want an exact match.

Try use 0 as the 3rd argument:
=match("ben franklin",a:a,0)





David wrote:

I'm using three seperate Match functions to find three items in Column A to
get the row they are on.
The first match is returning the right row number, 10. =MATCH("Ben
Franklin",A:A)
However, the second and third are not:
=MATCH("OHAC",A:A,1) returns 24 but is on row 36
=MATCH("Mister Sparky",A:A) returns 21 but is on row 50
I need the OHAC to return 36 and Mister Sparky to return 50

All three match functions are in column J
They all refer to range A:A.
Any help would be appreciated!

--

Dave Peterson

Duh...Again...YOU DA MAN!!
I'm getting brain overload...thanks Dave!

"Dave Peterson" wrote:

If you're matching on Text values, I bet you want an exact match.

Try use 0 as the 3rd argument:
=match("ben franklin",a:a,0)





David wrote:

I'm using three seperate Match functions to find three items in Column A to
get the row they are on.
The first match is returning the right row number, 10. =MATCH("Ben
Franklin",A:A)
However, the second and third are not:
=MATCH("OHAC",A:A,1) returns 24 but is on row 36
=MATCH("Mister Sparky",A:A) returns 21 but is on row 50
I need the OHAC to return 36 and Mister Sparky to return 50

All three match functions are in column J
They all refer to range A:A.
Any help would be appreciated!

--

Dave Peterson