change cell values based on criteria

I would like to ask for your help solving one of my problems.
In a database I have to change the cell values which meets the criteria defined.

In the sample file I attached there is "sheet1" where in A2 contains a value and B2, C2 contains two criteria which define a time range.
In sheet "database" I should change all values to "Q" in range BB4:BB15000 where
rows in range D4:D15000 meets criteria defined in Sheet1 A2
and are in the interval in range AD4:AD15000 defined the Sheet1 B2 and C2 value.

- enter a date in sheet1!B2 : 01-10-2011
- enter a date in sheet1!C2 : 31-10-2011

use a formula in column BB:

PHP Code: 

=CHOOSE(($D4=Sheet1!$A$2)*($AD4>Sheet1!$B$2)*($AD4<Sheet1!$C$2)+1;"";"Q") 


NB replace the ; into , if necessary

You could have adapted the formula yourself:

PHP Code: 

=CHOOSE(($D4=Sheet1!$A$2)*($AD4>Sheet1!$B$2)*($AD4<Sheet1!$C$2)+1;BB4;"Q") 


..And could have used it for the VBA-approach:

Please Login or Register  to view this content.