Display Table Headers in a Drop Down List

[grungefreak1]

Please see sample data Below:

Programmer....Java....C++....C#....COBOL

John............Yes.......No......No....No

Jane..............No......Yes.....Yes..Yes

Joe..............Yes...... No......No....Yes



Above is a data set with headers on top. Each programmer can program in certain languages i.e. yes under Java means they can program in Java.

I have created a drop-down list of "Programmer"names. Based on whichever name I select, I want to display the programming languages he/she can use. This involves finding "YES" across the row and grabbing the header of each relevant column and displaying the results in a readable format.

I have tried for a few hours to do this but cannot come up with a viable solution. This is part of a project I am working on for my own business so I would appreciate some guidance/help please.

GF

 

[VoG]

Maybe this http://www.contextures.com/xlDataVal02.html

 

[grungefreak1]

Maybe this http://www.contextures.com/xlDataVal02.html

Thanks, I just tried that but it's not working out too well for what I need.

GF