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.