Placing a value into a range of cell based on two dates

[michael.a7]

I have dates in columns like this:

25/09/06 02/10/06 09/10/06 16/10/06 23/10/06 etc


And on another worksheet I have:
5000 in cell A1 and then 02/10/06 in cell B1 and 16/10/06 in cell C1

I would like 5000 to appear under the column headings for 02/10/06, 09/10/06, and 16/10/06 in my first worksheet - based on the values in cell A1 and the date range in B1 and C1.

Is there a formula that can do this?

Any help would be very much appreciated. Thanks.

[Dav]

if dates are in a1:e1 on the first sheet

in a2 put if(and(a1>=sheet2!$b$1,a1<=sheet2!$c$1),sheet2!$a$1,"")

Then copy accross for the other columns

Regards

Dav