VLookup Function

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

When using the VLookup function, I am using "FALSE" as the
argument, for the "range_lookup" argument, because I only
want an exact match; however, it returns "#N/A" when there
is no exact match, as it's supposed to, but, I want it to
return a "0". What do I do ?

I have tried nesting it within a "IF" function, but
nothing I've tried has resulted in the return I want.
 
Back
Top