Hi I'm trying to to create a sheet that tells me all of the timekeepers that work on a client from data from another sheet.
Currently I have sheet that list all of our clients and I will like to add a column that list all of the timekeepers that work on the project. Normally I would use Index Match however, some clients have multiple time and index match only show one timekeeper is there a formula to show multiple timekeepers.
Here is the index/match formula I use: =INDEX({TimeKeeper}, MATCH([Matter Number]1, {Matter Number}, 0)
In the below example you can see the index match that only shows one name, however for client Red there should be 4 names. Any help would be appreciated.
