I have a data sheet that has a 13 month break in data that I need to write a formula for. I need it to return "" if the corresponding cell A is blank and I also need to add in that if the date is greater than June 30, 2012 and less than September 30, 2013 then it will return "". Here is what I have, the part in red is the portion I'm having issues with.
=IF($A5="","",If(and($A5>date(2012,6,30),$A5<(2013,9,30))),"",IF(ISERROR(VLOOKUP($A5,Data!$A:$BR,2,0)),0,VLOOKUP($A5,Data!$A:$BR,2,0)))
Bookmarks