If a name appears in either column B or C show me A

Here is my prediciment…. I’ll create an example

Column A Column B Column C

Job Primary Alternate

Sweep Joe Katie

Trash Katie John

Mop Erica Joe

Bathroom Steve Erica


Ultimately I would like to be able to Filter on a name i.e. Katie and determine what jobs Katie has, whether she is a “Primary” or an “Alternate” 

With Filtering just column B I lose the information from Column C meaning I wouldn’t be able to find out what Katie is an “Alternate” for. 

In a perfect world on a septerate sheet I would have a list of all the names and be able to select one and below it would show all the jobs (Column A) the person has. 

I’d appreciate any help!


By: Melissa

Leave a Reply

Your email address will not be published. Required fields are marked *