Eliminate the Vlookup #N/A result in Excel

[jrobin5881]

Good Morning,

Is there a way to eliminate the #N/A value when a vlookup does not find a match? Other then adding another column and doing another calculation on the vlookup results. I want the vlookup to look through my array and if it does not find a value I want a 0 to appear in the cell. The #N/A is messing up subsequent calculations.

Sample:
=(VLOOKUP($A2,FOTSUM!$A$2:$E$725,5,FALSE))+D2

 

[koresnordic]

=if(iserror((VLOOKUP($A2,FOTSUM!$A$2:$E$725,5,FALSE))+D2),0,(VLOOKUP($A2,FOTSUM!$A$2:$E$725,5,FALSE))+D2)

The iserror checks to see if an error occued, if so it responds with a zero, else it responds with the formula result.



Graham

 

[bluedragon2]

=IF(ISNA((VLOOKUP($A2,FOTSUM!$A$2:$E$725,5,FALSE))+D2),"",(VLOOKUP($A2,FOTSUM!$A$2:$E$725,5,FALSE))+D2)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[carrr]

Use ISERROR

http://www.techonthenet.com/excel/formulas/iserror.php

 

[jrobin5881]

Wow are you guy's fast!!! Thank you both - saved again.