MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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