ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   IS THERE ANY FORMULA IN EXCEL THAT CAN DO THIS? HLOOKUP MAYBE? (https://www.excelbanter.com/excel-discussion-misc-queries/234401-there-any-formula-excel-can-do-hlookup-maybe.html)

HERNAN

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


Don Guillett

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




All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com