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

[BrandonP2121]

Hello,

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 · Accepted solution]

@BrandonP2121 

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.

[#3]

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