MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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.

Posted by Ivan Moala on October 27, 2000 3:57 AM

try something like;


Assuming lookvalue in C3, range = B3:B12 and
find exact match.


Posted by Aladin.Akyurek on October 27, 2000 8:00 AM

You can also use ISNA in Ivan's formula instead of ISERR.