I have a list of users and which groups they report to:

User1 Group1
User2 Group1
User3 Group2
User4 Group2
User5 Group2
User6 Group1
User7 Group2
User8 Group3
User9 Group3

I need to be able to select the group from a drop down, and then show ALL users in that group.

Here's how I picture it:
Group 1 (dropdown selection)
User1 User2 User6
### #### ####
xxxx xxxxx xxxx

And the users should change as you change the group name, and then populate their information using VLOOKUP or Index(Match).

Right now my reference table has Agent with his/her related Group, and then a separate list of groups just for the drop down (if I use the Agent-Group column, it returns each group name multiple times in the drop down)

Any help at all would be appreciated!