How do I only get valid "answers" in a VLOOKUP function (no #N/A's
I remember reading a couple of years ago that a speed test showed that an
ISNA plus Match() combination was a more efficient error check then
Countif(), while either one of them was definitely much faster then a double
Vlookup().
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Biff" wrote in message
...
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
|