Excel 2007 : populating data after picking drop-down choice

Hi Everyone,

I'm trying to make data populate after choosing a field from a drop-down...which I got to work but the problem is it only shows one row of the data?

example: say I have Pre K - Grade 12 in a drop-down then I choose grade 12 and it has 14 people in there my formula "=IF($E14="", "", INDEX(Names!B:B, MATCH($E14,Names!$F:$F, 0)))" but it only shows one of the 14 on the sheet.

All my data are in on separate sheets in 1 workbook.

Can you please help me thanks.
---Will