I have an attached worksheet. I would like to enter a value (the example is 4000 in column A), and the next value from the sequence in column F is returned. So, in this example, the value of 5000 would be returned to column C). If I enter 7000, I would like 8000 returned, etc.
I've tried a formula, but it's not working. Copy-of-Book2.xlsx