Creating a list where entries meet specific criteria

Hi

I am hoping someone will be able to provide me with some guidance.

I am trying to create a list which will show values which meet a specific criteria.  The list will be on one worksheet with the values it will be built from held in another worksheet in the same workbook.

The worksheet that will be used to build the list is laid out as follows:

The list will need to return the names of the Small schools as shown in the third column (the Number of posters required does not need to be included in the list). There will be another worksheet which will have a list for the Large schools.  

I have tried using the IF function to build a formula and whilst this does build a list with the correct school names it leaves lines in where the school does not match the criteria.  So the formula will need to be able to build a list that excludes the non matching schools and not leave blank spaces where these would have appeared.

Any help with this will be really appreciated.

Thanks in advance,

Andy