INDEX, MATCH, COLLECT, CONTAINS ... oh my.
I have two worksheets. Worksheet A ("Verified Content Report") has about 100 columns. On each row are details about a specific asset. One of those details is in a column called "Owners," which contains one or more user IDs (comma-separated) for each individual "owner" of that asset.
Worksheet B has 2 columns: user IDs and the team to which that user belongs.
I need to "marry" these two worksheets into a report that will show all of the assets "owned" by users in a team. However, I cannot seem to figure out how to do this other than to know it's some combination of INDEX/MATCH and COLLECT or CONTAINS running in a column on the Verified Content worksheet that can be leveraged into a filtered report.
Thoughts? Suggestions? Coffee delivery?
Help Article Resources
Check out the Formula Handbook template!