Find Number in Column

[novamustangs]

How do I get Excel to return the value of a cell which is the first value greater than another number?

Ex.
Column A
1
15
67
257
384
689
1254

Let's say cell B1 contains the number 115.

I'd like Excel to tell me what number in Column A is the first number (down the column) greater than the number in B1 (should return 257). Also, can I get it to tell me in which row that number is located? (should return 4)

Thanks!

[Avner]

Try

=OFFSET($A$1,MATCH(B1,A:A,1),0)
and
=MATCH(B1,A:A,1)+1

hope it helps

[novamustangs]

I had to modify it a bit, but it ultimately worked. Thanks!