We help IT Professionals succeed at work.

Next number in a sequence

LiamMcKay
LiamMcKay asked
on
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
Comment
Watch Question

Try

=INDEX($F$2:$F$8,MATCH(A2,$F$2:$F$8,0)+1,1)
LiamMcKayHead of Technology

Author

Commented:
ssaqibh: That works really well, could you briefly explain how it works before I close this down?
Sure.

Match() looks for the value of A2 in F2:F8 and returns the position of that number in the range
Oops submitted early.

Then 1 is added to the position to get the position of the next number.

The index function uses this new position to fetch the desired number.