VLookup Function

[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.

 

[Frank Kabel]

Hi
the standard appraoch
=IF(ISNA(VLOOKUP....),0,VLOOKUP(...))

 

[Greg]

Thank you very much !

-----Original Message-----
Hi
the standard appraoch
=IF(ISNA(VLOOKUP....),0,VLOOKUP(...))

--
Regards
Frank Kabel
Frankfurt, Germany



.