Hi All,
How can i add multiple search to sumproduct?
I have tried the below formula and got an error

Thanks

=IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($A$1:$A$3,C1)))))>0,"1",IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($b$1:$b$3,C1)))))>0,"2","")