If Formula result is 0 then output value =" "

[omairhe]

Hello,

I am wondering how will my formula below will output me " " (double space) if the resulting value of this formula is equal to 0

Formula:
=IFERROR(INDEX(A:A,MATCH(C1,B:B,0)),"")

Any help will be appreciated.

Thanks in advance.

 

[Phuoc]

If column A is the numeric: =IFERROR(1/(1/INDEX(A:A,MATCH(C1,B:B,0))),"")

If column A is the text: =IFERROR(INDEX(A:A,MATCH(C1,B:B,0))&"","")