# Help W/Small Formula

#### Evagrius Ponticus

##### Well-known Member
Hi - This formula isn't working for me. If M3 has any of the values in range b3:b22 in another worksheet - then place a one in the cell w/the formula . . .I confirmed with cse . . .thanks for any help . .

=IF(M3=STATS!\$B\$3:\$B\$22,1,0)

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
will the word stats! be in M3 ? if so the word need to be like this,

=IF(M3="STATS!"\$B\$3:\$B\$22,1,0)

if not sorry.

STATS is the name of the page . .

i beleive you need to do the following:

PHP:
``=sum(IF(M3=STATS!\$B\$3:\$B\$22,1,0))``

confirmed with CSE.

Here's one way:

Code:
``=(COUNTIF(STATS!B3:B22,M3) > 0)+0``

yup! Thanks for the help fellas!!

Replies
11
Views
396
Replies
3
Views
293
Replies
5
Views
558
Replies
9
Views
3K
Replies
4
Views
470

1,196,501
Messages
6,015,563
Members
441,901
Latest member
joshtfin

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back