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