Lookup Ranges

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