how do i get exact matches in a vlookup fomrula

[shark1966]

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

 

[Biff]

Set the 4th argument to FALSE or 0:

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

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

Biff

 

[shark1966]

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

 

[Dave Peterson]

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

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