View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher770[_3_] Christopher770[_3_] is offline
external usenet poster
 
Posts: 1
Default Ignoring formula results of #N/A


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