finding the first number in list that meets criteria

Hi all,

I am trying to find the FIRST score in column A that meets or exceeds the target in column C, and entering the number of elapsed days in column D.

I attach a simple example spreadsheet with the first few correct answers in column D.

Many thanks

ps I have now retired, so do not post so frequently.

Try...

D2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=MATCH(TRUE,B2:$B$40>=C2,0)-1

Hope this helps!

Dominic, that was quick, many thanks. I tried it in my actual application, it works as such, but I have only monday to friday dates in the date column, with some dates missing, so is there a way to return the DATE on which the match is found, thanks.

Try...

=INDEX(A2:$A$40,MATCH(TRUE,B2:$B$40>=C2,0))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Thanks, Dominic, I just added a minus today's date bit and it now gives me the elapsed days to hit target. Out of interest I am using it to track share prices and to monitor various automated buying and selling scenarios. Thanks again.