return of a row no of next highest value

Hi,

Just a question on searching through a series of numbers.

I have a sheet with a rows of numbers in a sequences, but no necessarily an increment of 1.

For eg: -

1
2
3
8
9
10

(Thus 3 jumps to 8 etc)



Let's say I come up with a target value of 4.

I want to create formula that searches through this series of figures and returns the row number of the next highest value of 4.

In this case the next value from 4 in the list would be 8 (ROW 4).

How would I create a formula in order to return the ROW number 4?


Thanks.

Zal

try this:

Formula:

Please Login or Register  to view this content.

You can replace number 4 with some cell reference (B1)

Thanks for your all your answers. But Fotis, you hit the nail on the head on this one!

Zal