|If you want to increment your "dates" (40725) by 1 as you drag the formula down, take advantage of the ROW() function:|
ROW() returns the Row number of whatever Row it is used in.
In any cell in Row 1, use this and drag it down, since 40724 + 1 = 40725
=VLOOKUP(40724+ROW(), Stats, 2, FALSE)
If you need to start your formula in a Row other than 1, simply subtract the starting Row number from 40725, e.g.
In any cell in Row 5, use this and drag it down, since 40720 + 5 = 40725
=VLOOKUP(40720+ROW(), Stats, 2, FALSE)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.