Formula to return column number of next match

[jc352]

How can this formula be changed to allow it to be 'pulled down' and find the next match in the range?


=COLUMNS(AGGREGATE(15,6,COLUMN(Test!$C$3:$P$32)/(Test!$C$3:$P$32=DATE($A$1,MONTH(DATEVALUE($A$2&1)),$C$4)),1))

 

[Fluff]

Try

=COLUMNS(AGGREGATE(15,6,COLUMN(Test!$C$3:$P$32)/(Test!$C$3:$P$32=DATE($A$1,MONTH(DATEVALUE($A$2&1)),$C$4)),rows(a$1:a1)))