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
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??
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","")
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.