Excel query

Hi,

I have attached a spreadsheet outlining what I want to achieve.

Basically these are the following process steps: -

1) The User enters a claim date.
2) The User can use a drop down/combo box to choose a Scheme. The only schemes which should appear in the drop down box are those where the claim date falls within 'To' & 'From' dates on data list.
3) Once the relevant scheme has been choosen the remaining fields are populated automatically.

Any help you can give me would be most appreciated.

Regards