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
Bookmarks