The title may be as vage as possible, but i'm new at this and i'm trying.
I want have a sheet with the setup:
User Role | Permission
But the a permission could also apply for multiple User roles,
So i want to create a more user friendly sheet Where i plot:
User role x | User role y| User role z
Permission 1
Permission 2
Permission x
And want to display this to true or false, or something.
But i am kind of stuck because my wildest VLOOKUP is just a lookup for 1 value in another sheet. i also saw some form of match and index combined, maybe that's something that could work?
Could you guys help me out with this?
Aucun commentaire:
Enregistrer un commentaire