- Sep 25, 2014
Hello everyone. I was given a spreadsheet of locations in column B with managers listed in columns C though G depending on how many a location had. I have a separate spreadsheet where I need to list whether the associate is a manager or not. I am thinking INDEX and MATCH but I have never done one. Any ideas or a better solution?