=if(iserror(vlookup(...)),0,vlookup(...))

If you're using xl2007:
=iferror(vlookup(...),0)



shark1966 wrote:

That worked great! Thanks. I am now receiving #N/A where there are no values.
How can I force the N/A to 0???

"Biff" wrote:

Set the 4th argument to FALSE or 0:

=VLOOKUP(A1,B1:C10,2,FALSE)

=VLOOKUP(A1,B1:C10,2,0)

Biff

"shark1966" wrote in message
...
in my vlookup formula, I am finding values that shouldn't have values are
returning the value for the closest match.




--

Dave Peterson