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

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

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"HERNAN" wrote in message
...
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