Lookup Ranges

[DanSherwood]

Hi,

I have a worksheet where i have 2 date values, a start date and an end date.

On another worksheet i have a load of rows of data headed by week.

I need to lookup the start date and end date, and for every week from the start date to the end date I need to put the corresponding data into the result cells. Thus if the start week is 1st jan and end week is 12th feb, i need the lookup to print the data for each of the weeks in between those 2 dates in the other sheet, not just the 2 discrete weeks?

Is this possible? Is there a way to lookup in this way?

Thanks

Dan

[starguy]

Hi,

I have a worksheet where i have 2 date values, a start date and an end date.

On another worksheet i have a load of rows of data headed by week.

I need to lookup the start date and end date, and for every week from the start date to the end date I need to put the corresponding data into the result cells. Thus if the start week is 1st jan and end week is 12th feb, i need the lookup to print the data for each of the weeks in between those 2 dates in the other sheet, not just the 2 discrete weeks?

Is this possible? Is there a way to lookup in this way?

Thanks

Dan

Please attach a sample file in zip format.

[starguy]

Please reupload file. It gives error after downloaded.

[DanSherwood]

Apologies, not sure of what the problem is. I have attempted to post again, not sure what to do if this doesn't work, any suggestions?

[starguy]

Apologies, not sure of what the problem is. I have attempted to post again, not sure what to do if this doesn't work, any suggestions?

It still gives error. it there are two files attach them seperately.

[DanSherwood]

Only one file...

[starguy]

ok I got it...

[DanSherwood]

Any joy with this one or am i doomed to failure!?