Find next cell w/value >2000, Pls Help!

[Adresmith]

Hi. I am pretty experienced with excel but I have run into a problem I do not know how to solve. I have a list of numbers in column K. I want to find each value in column K greater than 2000000 and list in column L the closest value less than 2000000 above it. There are a total of 4000+ lines so I really need to find a formula to do this for me. See example below.

Any suggestions would be much appreciated!

Thanks,
Adrianne

10000001
20000001 10000001
20000002 10000001
10000002
20000003 10000002
20000004 10000002
10000003
20000005 10000003

[Ron Coderre]

Try entering this formula in Cell L1 then copying it down.
=IF(K1<20000000,"",INDEX(K$1:K1,SUMPRODUCT(MAX(--(K$1:K1<20000000)*ROW(K$1:K1))),1))

Does that do what you want?
Ron

[Adresmith]

It worked perfectly...Thank you so much!!!!!