VLOOKUP
Posted by Koen Swolfs on October 27, 2000 2:37 AM
How do I act to receive a 0 (zero) when a lookup value isn't found in the lookup range?
For example: the lookup value is 02/01/2000 in the lookup range I have 01/01/2000, 03/01/2000,... but not 02/01/2000. I'd like to have "0" as result.
Please help me out.
Thanks.
Posted by Ivan Moala on October 27, 2000 3:57 AM
try something like;
=IF(ISERROR(VLOOKUP(C3,B3:B12,1,FALSE)),0,VLOOKUP(C3,B3:B12,1,FALSE))
Assuming lookvalue in C3, range = B3:B12 and
find exact match.
Ivan
Posted by Aladin.Akyurek on October 27, 2000 8:00 AM
You can also use ISNA in Ivan's formula instead of ISERR.
Aladin
