Guys I need help in extracting data from a table.


Excel pic.jpg
eg.

A-team B-team D-team C-team
sam X X
pat X X
john X X
peter X

I want to know what are the teams in which sam a member. Peoples' names should be selected from a dropdown menu and names of the teams should be displayed below the menu in alphabatical order.

Can u help me?