If your VLOOKUP formula looks likeOn 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!!
=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)
Like this thread? Share it with others