"david" wrote:
I have uploaded the problem file to savefile.com
http://www.savefile.com/projects/674184

Here's the implemented file:
http://cjoint.com/?hej7AWtVYv
Incident_Book_for_playY9.xls

In sheet: Printout,

In A6, A6 copied across to K6, then filled down to K100:
=IF(ROW(A1)COUNT($O:$O),"",INDEX(Y9Incidents!A:A, MATCH(SMALL($O:$O,ROW(A1)),$O:$O,0)+8))

We need to adjust with a "+8" to the result returned by MATCH since the
source data in sheet: Y9Incidents begins in row 14 and the formula's starting
row here is row 6.

The criteria col O
In O6 filled down to say O100 (say):
=IF(OR(Control!$C$9="",Control!$C$10="",Control!$C $10=""),"",IF(Y9Incidents!B14="","",IF(AND(Y9Incid ents!B14=Control!$C$9,Y9Incidents!D14=Control!$C$ 10,Y9Incidents!D14<=Control!$C$11),ROW(),"")))
(Leave O1:O5 empty)

And for a neater look, we can suppress extraneous zeros in the sheet
via clicking: Tools Options View tab Uncheck Zero values OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---