Formual Help - Duplicate Dates

[ststern45]

Hi everyone,

Need help with a formula.

In cell range A1:A365 I have the numbers 1 through 365

In cell range B1:B365 I have the dates. Most recent date in cell B1 March 1, 2019

In cell B2 I have the same date March 1, 2019

Cell B3 = February 28, 2019
Cell B4 = February 28, 2019
etc. etc. all the way down to cell B365

My question is this.

In cell C1 = March 1, 2019
In cell C2 = March 1, 2019

In cell D1 I would like to enter a formula similar to index/match that will give me the value of 1 (match the 1st instance of March 1, 2019)
In cell D2 I would like to enter a formula similar to index/match that will give me the value of 2 (match the 1st instance of March 1, 2019)

Thanks in advance!!

 

[6StringJazzer]

Because you specifically mention index/match I think you already know how to do this. For D1:

=INDEX($A$1:$A$365,MATCH($C1,$B$1:$B$365,0))

and copy down.

 

[kvsrinivasamurthy]

Post an image of sample data and results required.

 

[Fluff]

Maybe
=INDEX($A$1:$A$28,AGGREGATE(15,6,ROW($A$1:$A$228)-ROW($A$1)+1/($B$1:$B$28=C1),ROWS($1:1)))