If match then put a 1 next to it (?)

[San Antonio Heat]

I have two worksheets, page 1 has names in them. So A1 has nothing and b1 has Dallas in it.

In sheet 2, if I put Dallas anywhere in the A column, I want cell A1 on sheet 1 to show a 1 since it matches on sheet 2. Is this possible?

 

[San Antonio Heat]

never mind I did it, thanks

 

[San Antonio Heat]

Only problem is if I use match and get 1 for True, how do I get rid of the #N/A if they do not match?

=MATCH(B2,Sheet2!A1:A29)

If they don't match I get a #N/A, I really need that to read 0

 

[Aladin Akyurek]

Only problem is if I use match and get 1 for True, how do I get rid of the #N/A if they do not match?

=MATCH(B2,Sheet2!A1:A29)

If they don't match I get a #N/A, I really need that to read 0

Only problem is if I use match and get 1 for True, how do I get rid of the #N/A if they do not match?

=MATCH(B2,Sheet2!A1:A29)

If they don't match I get a #N/A, I really need that to read 0

=MATCH(B2,Sheet2!A1:A29)

would mean that A1:A29 is sorted in ascending order. If so, you shouldn't get #N/A, unless B2 < Sheet2!A1.

If sorted...

=IF(B2 < Sheet2!$A$1, 0, (LOOKUP(B2,Sheet2!$A$1:$A$29)=B2)+0)

If not sorted:

=ISNUMBER(MATCH(B2,Sheet2!$A$1:$A$29,0))+0