Quote Originally Posted by engrexcel View Post
Yes, that helped a ton! Thanks! Is there a way to get the formula so it grabs the data the first time 1000 is crossed? I'm not really concerned with any occurance of 1000 after it has been reached.

1.463 149.627 1.044 0.985 999.87

That was why I posted that set of numbers.
Try:

=INDEX(A$2:A$5000,MATCH(TRUE,$E$2:$E$5000>=1000,0)-1)

confirmed with CTRL+SHIFT+ENTER and copied down.