MATCH and A:A

  • Thread starter Thread starter Ty
  • Start date Start date
T

Ty

=IF(NOT(ISERROR(MATCH(A2,Tyrone_Fan!A:A,0))),"Matched","nomatch")

I don't understand what the above is doing. I changed the ??? name to
Tyrone_Fan to protect the company.

What exactly is the above doing?

A2?
A:A, 0?


Thanks,
Ty
 
=IF(NOT(ISERROR(MATCH(A2,Tyrone_Fan!A:A,0))),"Matched","nomatch")

I don't understand what the above is doing.  I changed the ??? name to
Tyrone_Fan to protect the company.

What exactly is the above doing?

A2?
A:A, 0?

Thanks,
Ty
Click to expand...

Hello Ty,

If A2 is included in column A of sheet Tyrone_Fan then you get
"Matched", otherwise "nomatch".

I would use
=REPT("No ",ISERROR(MATCH(A2,Tyrone_Fan!A:A,0))) & "Match"

:-)

Regards,
Bernd
 
=match()
is looking for an exact match (that 3rd parameter of 0 means exact match)
between the value in A2 of the sheet with the formula and column A of Tyrone_Fan
worksheet.

If there is no match, then =match() returns an error. If there is an exact
match, then =match() will return the row number in column A of that Tyrone_Fan
worksheet for the first match.

I think it would be more "normal" to do something like:

=if(isnumber(match(a2,tyrone_Fan!a:a,0)),"matched","nomatch")

(at least it makes more sense to me that way)
 
Back
Top