G Guest Sep 30, 2006 #1 in my vlookup formula, I am finding values that shouldn't have values are returning the value for the closest match.
in my vlookup formula, I am finding values that shouldn't have values are returning the value for the closest match.
B Biff Sep 30, 2006 #2 Set the 4th argument to FALSE or 0: =VLOOKUP(A1,B1:C10,2,FALSE) =VLOOKUP(A1,B1:C10,2,0) Biff
G Guest Sep 30, 2006 #3 That worked great! Thanks. I am now receiving #N/A where there are no values. How can I force the N/A to 0???
That worked great! Thanks. I am now receiving #N/A where there are no values. How can I force the N/A to 0???
D Dave Peterson Sep 30, 2006 #4 =if(iserror(vlookup(...)),0,vlookup(...)) If you're using xl2007: =iferror(vlookup(...),0)
