Cashflow sheet: lookup 30 days prior and get value

  • Thread starter Thread starter mchael
  • Start date Start date
M

mchael

I tried searching google and these forums for an answer but was unabl
to find one, hence posting now. I suspect I dont know what to loo
for.

The problem I have.

I have a week to week cashflow where the date headers are:

3 SEPT 2004 | 10 SEPT 2004 | 17 SEP 2004 and so on

Within the sheet lets say on the 17 SEPT 2004 coloum, I want to loo
back 30 days and pick up a value used in the same row.

I was able to use

=MATCH(H3-30,$D$3:H3,-1)

To lookup the dates and pull the right week.


Then I tried using

=INDEX($D$3:$BU$35,27,(MATCH((H3-30),$D$3:h33,-1)))

To be able to get the data from the row within the coloumn match found
WIth the Index I set the entire cashflow to look into but I always get
#N/A

I am using Excel 2003


Thank you in advance for any assistance or tips you may provide.

Michae
 
Back
Top