vendredi 27 février 2015

Excel VLOOKUP(sum of two values, array(sum of value 1 + 2)

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