I'm trying to use a series of tables to get me to a set of results, but am struggling at the moment. Here goes...

My first worksheet has Employees and their Functions ie:

Name Function
==== ========
Emp 1 Sales
Emp 2 Finance
Emp 3 Management

My second worksheet contains data about the functions in truth-table style (0 or 1):

Function Property 1 Property 2 Property 3
=======================================
Sales Yes Yes No
Finance No Yes No
Management No Yes Yes

What I want to be able to do is Select an employee name and only display the property *labels* if 'Yes' appears against the Function for that particular employee.

ie. I select the name 'Emp 3' and in my new sheet, I see displayed the label:

Property 2
Property 3

I hope this is clear - thanks in advance for any help.
Ranj