| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
=INDEX(A1:A500,MATCH(DATEVALUE("2/20/2005"),A1:A500,FALSE)-1)
OR =INDEX(A1:A500,MATCH(B1,A1:A500,FALSE)-1) WHERE B1 contains an actual date or =IF(ISNA(MATCH(B1,A1:A500,FALSE)),"No Match",INDEX(A1:A500,MATCH(B1,A1:A500,FALSE)-1)) with some error checking "Buffett" wrote: I need to write a formula that will lookup a cell value in a table and return the value one cell above the look-up value. I.E. I would like to look-up the value in cell A220 (say it is 2/20/05) in table A5:A100, if 2/20/05 is in cell A10, I want to bring back the value in A9. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
