I think your problem is that you have only provided an option in the IF
statement for a TRUE outcome - you have not specified what to do for a
FALSE outcome

the correct syntax is =if(condition,reponse if true, response if
false)

Try this =IF('Daily Tracker'!E4:E1000="No",'Daily
Tracker'!A4:A1000*,""*)

this will leave a set of blank lines instead of false. If you want to
skip the lines alltogher, you could try sorting (not sure what that
will do) or else you will need VBA

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555148