How to get rid of empty cells.

[nicholes]

i want automatically filled data in customers sheet when i enter his name only (in other sheet)

i am using this formula but this gives me empty cell in between when name comes after a few cells

=IF('all people'!A3:A6='all people'!$K$1,'all people'!B3:B6,"")

some one gave me example workbook but that formula is working in the same sheet


and i need it to work in another sheet and i could not do that


please download sample work book to understand this formula and my problem as well