VLookup: Range_Lookup

[Denny]

On a value of FALSE where it returns the exact match or
#N/A: instead of getting the #N/A, is there a way for me
to have it return a value of zero (or someother value I
may want). I'm trying to eliminte the #N/A value.

 

[Arvi Laanemets]

Hi

=IF(ISERROR(VLOOKUP(...)),"",VLOOKUP(...))

 

[J.E. McGimpsey]

one way:

=IF(ISNA(MATCH(A1,J:J,FALSE)),0,VLOOKUP(A1,J:K,2,FALSE))