To further continue with the above:

If I had a Timeline, i would like to locate a cell adjacent to a particular
date in order to start a flow of data...is there a formula for that?

eg
scenario required: data = 4.5% from Aug-07
A B
1. May-07
2. Jun-07
3. Jul-07
4. Aug-07 4.5%
5. Sep-07 4.5%
6. Oct-07 4.5%

scenario2 required: data = $593,299 at Jun-07
A B
1. May-07
2. Jun-07 $593,299
3. Jul-07
4. Aug-07
5. Sep-07
6. Oct-07

Thanks heaps,


Dave