How do i stop if function returning a number which contains the same digit?

[KWarlock]

Am using the formula:

=IF(ISNUMBER(SEARCH("3",H5)),"COLLECT"," ")

to return the text COLLECT in ,say, I5 if a 3 is input in H5. It seems that if a 13 or 23, or any number containing 3, is input in H5 then COLLECT also appears when I only want it to show COLLECT when 3 is used? Can anyone help please?

[Paul]

Hi KW, welcome to the forum.

Why can't you just use

=IF(H5=3,"COLLECT","")

?

[KWarlock]

Thank you Paul, as a novice I am maybe trying to overcomplicate it.

But trying to have it so if 3,6,9 or 12 is input then they all show COLLECT? Can't seem to get the formula right with what you suggested?

Thanks

[Paul]

With multiple possible values, perhaps try:

=IF(OR(H5={3,6,9,12}),"COLLECT,"")

[KWarlock]

Thanks Paul! Seems to work great. Very much appreciated.