Skipping rows on an IF statement

[Thoron6]

Afternoon all,

This will be a simple one for somebody out there but here goes.

I have 3 tabs (Summary, sheet 2, sheet 3)

All three tabs have the same columns in the same order. However, there is only data in the summary tab at the moment.

Name, Address, Town, Telephone number

These are the column headings. I want to do an IF statement that returns the rows IF the town matches a criteria.... So so far I have: "=IF('Summary'!$C:$C="Manchester",'Summary'!A2,"")"

This is bringing back the correct data but when I fill down it is including the blank rows. How can I get it to automatically add in the next row down when a certain town is entered in the summary tab? So each row is filled out with no blanks?

Thank you!

 

[Thoron6]

I've looked at array formulas and indexing but not sure if this is what I need to get it to work?