looking for kind a vlookup with multiple search and compare criteria

Hi,

i'm having following problem:

A functional role consists out of a set of application rights.
I have a list of users with their application rights.
I want to figure out if I can replace the users rights with a functional role.

Example:
Funct_Role_1 = Appl_Right_A, Appl_Right_B, Appl_Right_C
Funct_Role_2 = Appl_Right_A, Appl_Right_D
Funct_Role_3 = Appl_Right_D, Appl_Right_E

If User1 has Appl_Right_A, Appl_Right_D, I would like VBA to point out the user can be given Funct_Role_2
If User2 has Appl_Right_A, Appl_Right_D, and Appl_Right_E, I would like VBA to point out the user can be given Funct_Role_2 and Funct_Role_3

Can anybody point me out if/how this can 'easily' be done in vba ?

Thanks in advance.

i have in sheet one:
column A: application
column B: Functional Roles
column C: Application Rights

in an other sheet i have per user the application rights.

hope this helps ?

ok, hopes the attachment makes it more clear. The first two sheets (input_role & input_app)are input sheets, the third one,
is the expected result which i filled in manually ... It are all strings.

Thanks for your time.

Thanks, Olly!