Write your formula like this:
IF(ISERROR(VLOOKUP(A5-Recovery_lag,$A$5:BA$364,21)),"",VLOOKUP(A5-Recovery_lag,$A$5:BA$364,21))
This says...if the vlookup returns an error (#N/A is an error), then
return a blank, otherwise return the result.
Hope this helps
Christopher
--
Christopher770
------------------------------------------------------------------------
Christopher770's Profile:
http://www.thecodecage.com/forumz/member.php?userid=188
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=69780