Using formula to display a message if a certain number is shown in a column

New Contributor



I am trying to get Excel to look at the column I have highlighted for some certain numbers, and if those numbers are in that column I want to display a message. I tried using some different IF formulas but was not having any luck. Does anyone here have any ideas?



Thank you!


2 Replies
best response confirmed by BrandonP2121 (New Contributor)


Maybe like this.

=IF(OR(ISNUMBER(SEARCH(3,D3)),ISNUMBER(SEARCH(9,D3))),"output message","")

This is the formula in cell F3 in the example.

=IF(OR(D3=4108177,D3=4248742),"certain message","")

This is the formula in cell E3 in the example.

certain numbers in a cell.JPG

Thank you, I just had to tweak it a little bit but this solved my problems!