Remove 0 from Column

[vasc]

Hi my friend

In column D i have unnecesary 0 after formula
{=IFERROR(INDEX($J$3:$J$ 5,MATCH(1,COUNTIF(C3,"*" &J$3:$J$15&"*"),0)),"" )}

how remove that 0 ???


thank in advance

[KOKOSEK]

Into D3:

Please Login or Register  to view this content.

of course to accept with CSE (I know that you know that).
and drag it down.

[CK76]

Try...

Please Login or Register  to view this content.

Confirmed as array (CTRL + SHIFT + ENTER)

NOTE: This should be only be used when formula always returns text.

[vasc]

both solution work...
thanks my friends..
SOLVED

[CK76]

You are welcome