SEARCH formula is resulting #VALUE!

Hi everyone

I have a case that i want convert SEARCH result to "OK" "Not OK" output

I use IFS and combine it with SEARCH

Here is my formula :

=IFS(SEARCH("Terima";A2);"OK";SEARCH("Longshift";A2);"OK";SEARCH("Produksi";A2);"OK")

But, why the second and the third logical resulting #VALUE!

Error IF SEARCH.png

My cell format is General and i have typed my formula (not pasted formula)


Any idea/solution ?

Thank you

Error IF SEARCH.xlsx

Cell B2 formula Drag down

Formula:

Please Login or Register  to view this content.

	A	B	C	D
1	Penerimaan	Result		search
2	Terima FG Longshift	0k		terima
3	Longshift Penerimaan FG P1	0k		Longshift
4	Longshift Penerimaan FG P2	0k		Produksi
5	Longshift Penerimaan P1	0k
6	Longshift Penerimaan P2	0k
7	Jadwal Produksi	0k
8	produksi 7 jam kerja	0k
9	produksi 7 Jam	0k

B2=IF($A2<>"",IF(SUMPRODUCT(COUNTIF($A2,"*"&$D$2:$D$4&"*"))>0,"0k","no match"),"")

Copy down