Replace #N/A with 0

T

thefeokas

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?
 
F

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))
 
B

BillCPA

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

thefeokas

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!
 
Top