IS THERE ANY FORMULA IN EXCEL THAT CAN DO THIS? HLOOKUP MAYBE?

[HERNAN]

A formula that:
Finds the first number in the row bigger that "10", and when it finds it
return the value on the same column but on row 1 (for the next row also
always row 1)

Ie: Column A has already the results I want.

Result B C
1 1/1/2009 2/1/2009

3 2/1/2009 2 12
4 1/1/2009 11 15
5 2/1/2009 -2 25

 

[Don Guillett]

=INDEX(A:A,MATCH(10,B2:B100)+1)