how to use iserror function

[delta]

my formula is below i need to use iserror function because result will be 0 (zero) will not be show.
where put the iserror formula

=INDEX(Baze!$A$1:$D$1000, MATCH(B3,PSC_2016.xlsm!Sales_Party_Name,), MATCH(Formula!A2,Baze!$A$1:$D$1,))

 

[Nebu]

Hi:

IF(ISERROR(INDEX(Baze!$A$1:$D$1000, MATCH(B3,PSC_2016.xlsm!Sales_Party_Name,), MATCH(Formula!A2,Baze!$A$1:$D$1,))),0,INDEX(Baze!$A$1:$D$1000, MATCH(B3,PSC_2016.xlsm!Sales_Party_Name,), MATCH(Formula!A2,Baze!$A$1:$D$1,)))


You can also use if you have latest version of excel.

IFERROR(INDEX(Baze!$A$1:$D$1000, MATCH(B3,PSC_2016.xlsm!Sales_Party_Name,), MATCH(Formula!A2,Baze!$A$1:$D$1,)),0)


Thanks

 

[delta]

it is not working
still show 0 zero
i did not show 0 zero like blank sales

 

[Nebu]

Hi:

Your index formula may be wrong, "Iserror" is nothing but an error wrapping formula.

Thanks

 

[delta]

i upload file now i put vlookup formula and also show 0 (zero).
sheet 1 create vlookup formula
sheet 2 contain data

 

[bosco_yip]

i upload file now i put vlookup formula and also show 0 (zero).
sheet 1 create vlookup formula
sheet 2 contain data

Try,

B2 :

=IFERROR(1/(1/VLOOKUP($A2,Sheet2!$A$2:$C$50,2,0)),"")

C2 :

=IFERROR(1/(1/VLOOKUP($A2,Sheet2!$A$2:$C$50,3,0)),"")

Regards