Change Data Validation List Based On Value In Cell

[jeff]

Please see attached....in cell B5 & B13 when i select a Leaders name i want his Members to be available in range C5:C10 & C13:C18......if i change the leaders name i then want his members to be visible with a Dropdown List of all the members belonging to the Leader....So if i change from Chris (B5) to Dave (B5) i want Daves members to be visible with the dropdown list of members for Dave

Hope this helps