On 2002-03-22 11:53, RICK_D wrote:
I am working with a VLOOKUP formula. How can I subsitute the #N/A into a 0?
I don't want the results to say #N/A if it does not find the value. I want it to show 0.
Any help would be appreciated!!
Thanks in advanced!!
If your VLOOKUP formula looks like
=VLOOKUP(A1,$E$2:$G$40,2,FALSE)
use:
=IF(COUNTIF(
$E$2:$E$40,A2),VLOOKUP(A1,$E$2:$G$40,2,0),0)
If your VLOOKUP formula looks like
=VLOOKUP(A1,$E$2:$G$40,2,TRUE)
or
If your VLOOKUP formula looks like
=VLOOKUP(A1,$E$2:$G$40,2)
use:
=IF(ISNUMBER(MATCH(A2,
$E$2:$E$40)),=VLOOKUP(A1,$E$2:$G$40,2),0)