Ashe
New Member
- Joined
- Dec 2, 2023
- Messages
- 9
- Office Version
- 2021
- Platform
- Windows
The goal of this project is to create a table that shows whether or not associates have permissions to perform a task at work.
Column B contains associate logins.
Column C contains the task the associate is trained in.
Columns A and D contain irrelevant info that comes with the downloaded task file.
Associates can be trained in multiple tasks.
Example...
Etc etc...
This is what I'd ultimately like the end result to visually be.
The task file contains thousands of entries. Each task gets its own entry. If the associate doesn't have training, they don't appear on the list. I've tried [V/X/H]LOOKUP, INDEX, and MATCH in various combinations and haven't been able to get the document to return the correct information. It keeps getting stuck on the first entry it finds. Per the example, Cat has Stacking and it only looks at Cat having Stacking, completely ignoring that they don't have Sort, so it returns "Yes" for everything. Another problem is this list is dynamic. Alex could lose their Prep permissions tomorrow, and it would then be deleted from the list the next time it's updated.
I've previously achieved the results I want by having each permission as a column header with the associates trained within the respective column, but this new task file doesn't download like that. I could use VBA to adjust the document to a similar layout, but was hoping there may be a solution that doesn't require me setting that up.
Any help or suggestions are greatly appreciated!
Column B contains associate logins.
Column C contains the task the associate is trained in.
Columns A and D contain irrelevant info that comes with the downloaded task file.
Associates can be trained in multiple tasks.
Example...
This is what I'd ultimately like the end result to visually be.
The task file contains thousands of entries. Each task gets its own entry. If the associate doesn't have training, they don't appear on the list. I've tried [V/X/H]LOOKUP, INDEX, and MATCH in various combinations and haven't been able to get the document to return the correct information. It keeps getting stuck on the first entry it finds. Per the example, Cat has Stacking and it only looks at Cat having Stacking, completely ignoring that they don't have Sort, so it returns "Yes" for everything. Another problem is this list is dynamic. Alex could lose their Prep permissions tomorrow, and it would then be deleted from the list the next time it's updated.
I've previously achieved the results I want by having each permission as a column header with the associates trained within the respective column, but this new task file doesn't download like that. I could use VBA to adjust the document to a similar layout, but was hoping there may be a solution that doesn't require me setting that up.
Any help or suggestions are greatly appreciated!
