Replace #N/A with 0

[Guest]

I'm trying to replace the #N/A that I get in a VLOOKUP with a zero so that I
can use the result in a Multiplication formula. I've tried using this
formula as directed in several other posts but it doesn't seem to work:
=if(iserror(VLOOKUP(B10;'Item List With
Costs'!$A$2:$M$1247;11;FALSE),0,VLOOKUP(B10;'Item List With
Costs'!$A$2:$M$1247;11;FALSE))

Can someone see what I'm doing wrong?

 

[dcronje]

use ISNA() instead of ISERROR(

 

[Frank Kabel]

Hi
wrong parentheses. Try:
=if(iserror(VLOOKUP(B10;'Item List With
Costs'!$A$2:$M$1247;11;FALSE)),0,VLOOKUP(B10;'Item List With
Costs'!$A$2:$M$1247;11;FALSE))

 

[Guest]

Other possibilities might be found if you look under help for 'Correct a #N/A
Error'.

 

[Guest]

Thanks - This was part of my problem but it still didn't work. I discovered
that it will work if I replace the commas around the zero with semi-colons -
,0, replaced by ;0;
This combination of corrections solved my problem. Thanks to all that
responded!

 

[Guest]

Try this:

=if(iserror(VLOOKUP(B10;'Item List With
Costs'!$A$2:$M$1247;11;FALSE))=true,0,VLOOKUP(B10;'Item List With
Costs'!$A$2:$M$1247;11;FALSE))