![]() |
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 |
All times are GMT +1. The time now is 12:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com