I have the following list of data on an Excel sheet:

On column "B" I have a list of logins, and on columns "C-D-E" a list of tasks that the person performs.

Then, I have another list on which I'll select a login linked to a Process. I need the code to say "TRUE" or "FALSE" depending on two thinks:

1. First, it has to check if the login is in the previous list
2. If so, it has to check if the process is one of the Proc 1-2-3 for that login

If both options are happening, the answer should be FALSE, and it should be TRUE if the login is on the list but the process is not right (if the login is not on the list, nothing should happen, or at least the result is irrelevant).

Right now I have the following code:

I don't know how to change the green lookup array for the second "MATCH" formula, to check it on the login one (if the login would be "miguel" instead of "rosa", that array should be: C5:E5).

Any clue?

CodePudding user response：

you can try this