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