Easy Excel Formula Problem

[ajilejay]

All I want to do is modify this to say High Alert if true and leave the cell blank if false. Everything I have tried seems to give me an error and I know I am missing something silly.

=SUMPRODUCT(--ISNUMBER(SEARCH(A2,Sheet2!F:F)))>0

[mana]

data validation?

[offthelip]

Search returns a Number, or #Value
your isnumber function will return True or False
sumproduct function requires an Array as an input, ( not TRUE or False, or a number )

conclusion your formula will never work, what are you actually trying to do??

[mana]

I guess,

=COUNTIF(Sheet2!F:F,"*A2*")>0

but it's results same as yours?

[Pam in TX]

All I want to do is modify this to say High Alert if true and leave the cell blank if false. Everything I have tried seems to give me an error and I know I am missing something silly.

=SUMPRODUCT(--ISNUMBER(SEARCH(A2,Sheet2!F:F)))>0

Try this

=IF(SUMPRODUCT(--ISNUMBER(SEARCH(A2,Sheet2!F:F)))>0,"HIGH ALERT","")