Excel LookUp (Financial)

[Smoothas]

Hello

Im having a problem with my lookup formula which i have used for looking up a cell referance to the date plus one cell to the right.

for eg. the part im stuck on is when i want it to reference to A1, but bring back data in cell B3 instead of A3.
A B C
1 28-10 29-10 30-10
2 £10 £20 £60
3 £20 £40 £90

 

[SkipVought]

Hi,

1. I assume that you have REAL DATES that are formatted to DISPLAY the DAY and MONTH. If not, you really ought to.

2. Please post the code that you are using for your lookup. Also supply the lookup value, so that we have all the info that you have.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}