Dynamic Drop Down Lists

[Az566]

I have a sheet with Group Name and Group ID, under which I have Sub ID numbers and Sub names. On another sheet I want to select the Group Name to get the list of Sub Names populated in a column.

For example:

Bob's Family	1289731		Paul's Family	98012309
Bob	13		Paul	125
Andrea	37		Jimmy	67
Simon	12		Samantha	8
Paula	6		Tim	85

<colgroup><col><col span="2"><col><col></colgroup><tbody>
</tbody>

If I select Bob's Family from the drop down list, I want the table below to be populated with all the names of Bob's family.

Been trying with arrays but since I don't know which column will be selected I can't seem to do it?

 

[VoG]

This may help you http://www.contextures.com/xlDataVal02.html