| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula help on HLookup / VLookup ?? | Excel Worksheet Functions | |||
| HLOOKUP Formula Error | Excel Worksheet Functions | |||
| vlookup and hlookup in the same formula | Excel Discussion (Misc queries) | |||
| array formula with if and hlookup | Excel Worksheet Functions | |||
| formula using both vlookup & hlookup | Excel Worksheet Functions | |||
Hybrid Mode
