My understanding of what you wanted is, if you select (importance) 1, then you want to see list of name associate with importance 1.
If this is the correct, then I will suggest having a LIST box on the sheet, with First Name & Last Name concatenated. So if you select 1 then you should see the list associated with the importance.
Let me know if this helps.
Hi thanks for you suggestion. I have a straight table with just First Name and Last name and the expression i mentioned above so that i could see which names appeared twice in excel sheet. I also have a table box with all the attributes, Importance, Company etc. However when i click on importance 1, 2, or 3 the expression in my straight table no longer works.