Date on which value first occured

[Mylarbi]

Hi, please I need help to develop a formula.
In the data table, I have Names as row headings and Dates as column headings.
It shows what happens on each date.

I need a formula to return the date when STATD first occurred.
For instance, if specify NAME4, the formula should be able to return 19-Dec because it is in column G that STATD first occurred on row 4.
If I specify NAME1, the answer should be 17-Dec.
Thanks

 

[Fluff]

How about

=INDEX(B1:J1,AGGREGATE(15,6,(COLUMN(B1:J1)-COLUMN(B1)+1)/(A2:A5="Name4")/(B2:J5="STATD"),1))

 

[Mylarbi]

Hi Fluff, it work exactly as needed. Thanks and bless you.

 

[Fluff]

You're welcome & thanks for the feedback.