What Formula to use to lookup multiple cells and give one values? RBAC made simple

Hi everyone,

I am attempting to create a simple excel worksheet to calculate whether a person with multiple permissions assigned to them, essentially has a designated role. Most of the roles consists of multiple permissions and usually this work has been done manually in the past, however I really don’t know what I can use. I only really know how to use VLOOKUP, and not entirely sure its fit for purpose.

I have provided some sample data of what I am trying to achieve. Table 1 starts with a list of users and their permissions. 2nd table shows what certain permissions can accumulate too. The end result being a combination of permission or designated roles give to a person.

Can anyone advise me what I could use, or provide examples of what is better? Very happy to learn and achieve the end result myself. Will absolutely share end results with Forum once discovered

Cheers all

Adrien

Cool, thanks Alan. I will try it first thing in the morning when at work. Definitely never have used it and I do love a good add-on. My personal favourite is Fuzzy-lookup, haha. I will keep you posted on my results tomorrow.

Thanks so much Alan. Worked a treat this morning. Read up on it last night and did the merge. Was so quick and efficient. Many thanks! Adrien