Get number in sequence using vlookup or match in a live table

[himanshushekhar8]

I have a set of numbers against dates. That sequence goes 0,0,0,0,0,.....,0,1,2,3,4,5,5,5,5,5..... And so on.
I first wanted to extract the date at 1 and 4 only then at the next occurrence of 6 to whatever the number before repetition. But I was unsuccessful. If I could get help on this, I'd be greatful.

My second way around was that I tried getting the output of
0,0,0,0,0,.....,0,1,1,1,1,2,2,2,2,2..... Against
0,0,0,0,0,.....,0,1,2,3,4,5,5,5,5,5.....
So that I could use match & index.

The table is live and the size of table is 4X6900. Also, the place of occurrence of 1 or for that matter any number is not fixed.

 

[Special-K99]

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.