In the attached excel file, I have a vlookup formula in cell B2 to return an approximate value for the input date in cell B1. It returns the value I would expect from the data set, which contains no blank cells. I have similar data in columns F & G, but I made cells G8 & G9 blank for dates 1/1/2002 & 1/1/2003. I want a formula that will return the value of 3 from date 1/1/2001 with an input date of 2/15/2003 and not return a value of zero from the blank cell for date 1/1/2003. Any ideas how to accomplish this? The sample data I have provided is a simplified set from a more complex set of data.
Bookmarks