Return the first date the number X or higher (or lower) occurs?

[chasfh]

I would like to find a formula that will scan a column to return the date the first instance of a number or higher occurs.

Here's a sample table:

[TABLE="width: 147"]
<tbody>[TR]
[TD="align: right"]Mo-Day[/TD]
[TD="align: right"]1947[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 1[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 2[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 3[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 4[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 5[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 6[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 7[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 8[/TD]
[TD="align: right"]26[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 9[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 10[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 11[/TD]
[TD="align: right"]33[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 12[/TD]
[TD="align: right"]27[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 13[/TD]
[TD="align: right"]37[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 14[/TD]
[TD="align: right"]38[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 15[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 16[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 17[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 18[/TD]
[TD="align: right"]35[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 19[/TD]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 20[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 21[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 22[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 23[/TD]
[TD="align: right"]34[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 24[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 25[/TD]
[TD="align: right"]38[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 26[/TD]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 27[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 28[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 29[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 30[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD="align: right"]Jan 31[/TD]
[TD="align: right"]17[/TD]
[/TR]
</tbody>[/TABLE]

I would like to a insert a formula in which, if I were to want to find the date the first number of 32 or higher occurred, it would return January 11. If I changed the number to 35, it would return Jan 14. If I changed it to 40, it would return Jan 24.

Does such a formula exist?

 

[steve the fish]

Try:

=INDEX($A$2:$A$32,MATCH(TRUE,INDEX($B$2:$B$32>=D1,0),0))

 

[chasfh]

MAGIC! Thank you!

Bonus question: is there a way to determine the second instance, third instance, etc.?

 

[chasfh]

Actually, I should have also asked, is there a way to query for the final instance of each number?

 

[steve the fish]

Final:

=LOOKUP(2,1/($B$2:$B$32>=D1),$A$2:$A$32)

 

[chasfh]

Thanks for the solutions you provided!