Hi!
While both your suggestion and Gary"s "work", neither is as efficient as my
suggestion.
Why execute 2 lookups when the lookup_value is present?
Using Countif to verify that the lookup_values exsists is faster than using
IF(ISERROR or IF(ISNA.
Biff
wrote in message
ups.com...
Hi,
try to use ISERROR function:
=IF(ISERROR(VLOOKUP(A1;Sheet1!$A$2:$C$11;2;0));0;V LOOKUP(A1;Sheet1!A2:C11;2;0))
Marian
http:\\skolenieexcel.host.sk
|