matching number

[xoxo]

What is the best way to do this in formula to find matching number?

On A1 I have 123. The range is J7:O34 which has 3 digits per cell. Would like to have indicator of 1 or a 0 on B1 to let me know if there is a match (1) or no match (0).

I tried using =COUNTIF(J7:O34,"=A1") but does not work.

Appreciate any help,
xoxo

 

[jae113]

I'm not sure, but I don't think you need the quotes around =A1. Because then excel looks for a cell with that exact text in it. I'm trying it myself now

 

[Jonmo1]

Try

=COUNTIF(J7:O34,A1)>0

This will give TRUE or FALSE (not 1 or 0)

If it must be 1 or 0, then put the N function around it..

=N(COUNTIF(J7:O34,A1)>0)


Hope that helps.

 

[xoxo]

Thanks jae113 and jonmo1! +rep!