Just now I've found an interesting formula to find the first no sales date by lookup with First Blank Cell. I was trying to create a Daily Sales Tracking Chart with a combination of Line Chart and Area Chart in Excel 2016. For that, I have designed my data table as below: Image 1: Sample data table to find the first no sale date Now, In F2 cell, I was trying to find the first no sales date by matching Sales is blank. I have used below Array Formula to get my result in F2 cell: =INDEX(B3:B32,MATCH(1,ISBLANK(C3:C32)+0,0)) And surprised to get the result. This tutorial is described in another way like "How to match blank cell in Index-Match formula". I know that you can easily find the 9-Jun-20 with below LOOKUP formula, like this: =LOOKUP(2,1/(C3:C32<>""),(B3:B32))+1 or Array Formula: =INDEX(B3:B32,MIN(IF(C3:C32="",ROW(C3:C32)))-2) Hope this tutorial will help you sometime in your excel world. Thanks.