Hello All,
I have quite a doosey out here in my excel file. Please see that atached database. Basically I am collecting plans and assiging multiple attributes to them. So I want to display the data in several differnet ways. First, see all the plans that match a particular dataset. Second, search plans by attribute A and publishing organization. This will allow me to search all of Org A files for a particular term. Last constraint, is if I do not want to specify orginzatoin to search I want it to search all orgs. Can a forumla be written for this without VBA. Please see mock up I created. I made a sample of how it should work for a few cases. Any help would save my skin at work! Thanks.sample sheet.xlsx