build up an array using formulas
 

I want to see in a variable range (A) if a certain value occurs.
The first and the last cell of range A are determined by other values.

For example

In col 1 I got dates from 01/01/2005 till 31/12/2005 (DD/MM/YYYY)
In col 2 I got values like "CC", "VV", ... or nothing

In col 4 till 7 I got something like this
from till
0 01 January 2005 08 January 2005
1 09 January 2005 05 February 2005

In col 7 I would like to find the cell in col 2 where the value = "CC"
within the range defined by the from and till fields.
The value "CC" may normally only occur once in this range.

So I would need a function or something that translates the "from - till"
fields in a range of col 2 and than look for the value "CC" in this range and
return the date from col 1 on this row.

Can someone help me out ?
I already tried several combinations on match, index, lookup, ...