HLOOKUP using MATCH and INDEX

Side note: for the products for which I have no forecast, it returns the first date in the file (41395, or May 1st 2013)

Originally Posted by cocostar88

Side note: for the products for which I have no forecast, it returns the first date in the file (41395, or May 1st 2013)

for that you can probably just take the final working formula, and wrap it in an Iferror
=IFERROR(..workingformula..,$CN$2)

CN2 = the first date in the range.