My IF function isn't working when I try to pull out a specific word

Question

I am trying to have the cell populate if the word CAT|I is in a different cell. I am using the following function:

=IF(ISNUMBER(SEARCH("CAT|I,",F12)),"CAT I","NO")

Unfortunately it is showing up CAT I for all my CAT|II and CAT|III cells but NO for my CAT|I.

Please post some example data. Without knowing how your data exactly looks like, it's impossible to answer. — Máté Juhász, Commented Feb 11, 2022 at 17:36
You should provide the sample file or screenshot about this problem. — Lee, Commented Feb 15, 2022 at 9:07

MiG · Accepted Answer · 2022-02-11 17:33:40Z

1

If you remove that comma it seems to work as intended:

=IF(ISNUMBER(SEARCH("CAT|I",F12)),"CAT I","NO")

answered Feb 11, 2022 at 17:16

MiG

1,1001 gold badge7 silver badges18 bronze badges

Add a comment |

1 Answer 1