|A slight modification of Mike's solution works for me based on your example data:|
You can use a named ranged instead of cell references if that makes it easier:
However, I have one concern:
The number of rows between base lines 1 to 5 will always be changing so it is not consistent. It could go from 1 to 3 or 1 to 20?
That shouldn't be a problem as long as the date remains 1 row below the 15-0000-xxx value. If the number of rows between those 2 values varies, then it might be hard to find a formula based solution. We may need VBA if that is the case.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.