Indexing and matching data from date range and matching

Hi



I need help with a formula in excel 2010.

I have 2 workbooks

One has....

ref No startdate enddate value
A 1 3/01/12 7/02/12 56
A 1 8/02/12 1/03/12 45
B 2 1/01/12 15/02/12 36
B 2 16/02/12 04/04/12 59

In the other workbook I have it as

ref No 01/01/12 02/01/12 03/01/12...
A 1
B 2

I have to put the data form the value underneath the corresponding date in the 2nd workbook from the date ranges and the matched ref and No. I do understand that the value will go under many individual dates...that's what I want.

Does anyone know of a formula that can index match and sort this data accordingly?

Also, to copy and paste the formula so the data matches the ref and No going down the column and matches the date going across the top row?

Hope you can help

Thanks in advance

Ricky

Cheers for the reply.

Will have a go and let you know how it goes.

Thanks again!!!