PDA

View Full Version : Easy Excel Formula Problem



ajilejay
10-01-2016, 06:13 PM
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
10-01-2016, 08:52 PM
data validation?

offthelip
10-02-2016, 12:21 AM
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
10-02-2016, 04:14 AM
I guess,


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

but it's results same as yours?

Pam in TX
10-18-2016, 09:30 AM
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","")