Providing info on tab, based on other tabs with parent child relationship.

Hi,

This post/question is based on a simplified verion of a security-matrix that is te be audited in the company and also audited against the real time security-tables in external system. I changed things to recognizable terms.

What would be the best way to solve the task below?

We have a PDF-image based on tab "FuntionRole_matrix" that is periodically audited against the actual situation. Thati is why this tab is not edited by hand but partially based on two additional tabs that are provided from another third party system.
These additional tabs are "RoleTask_matrix" and "TaskTool_matrix"

In Tab "FunctionRole_matrix" we manually fill the departments, job-titles per department and de roles assigned to the specific job-title.
In Column D we have a picklist of all the known Roles, as found in tab "RoleTask-matrix"
After choice the Role_ID is provided in column E. (via cell function: =X.ZOEKEN(D2;RoleTask_matrix!$A$2:$A$6;RoleTask_matrix!B$2:B$6;"Not found" (=V.Lookup in dutch Excel verison + semicolons different from english functions)
The Top row is filled by a lookup of all the possible tasks.

In the FunctionRole_matrix we provide insight in de assigned tasks within a role by a lookup-function in tab "RoleTask_matrix" (via cell function in topline: =X.ZOEKEN($D$1;RoleTask_matrix!$A$1:$A$1;RoleTask_matrix!E$1:E$1;"Not found")

(and for cell F2 etc.. the X is set by =X.ZOEKEN($E2;RoleTask_matrix!$B$2:$B$6;RoleTask_matrix!E$2:E$6;"-"))

Since we have to provide full insight in the relation between the jobtitle, the tassk within te job en the tools/matrials provided for the job we show the tools/matrials provided on the same line as the role in de FuntionRole_matrix. So that we can provide a signed PDF-copy of this excel-tab.

The tools provided must be determined by looking for the, via lookup determined, X-es per role. When an X is detected we have to determine de task provided in the topcel of that row. With this task-ID value we need to search in the tab "TaskTool_matrix" and look for the checked tools/materials that should be provided for every jobtitle that has that task.

Roles can overlap on tasks and this can also be the case for the tools/materials.
We just need an X on FuntionRole_matrix kolom AB etc.. to see what has to be provided to a person in every job-title.

Since there is no VBA-knowledge present i cannot bring this Excel sheet live with a button that sets all the X-es as of column AB. Personally i can do it, but withoud future support this cannot be the case. The solution needs functions in cells to provide the information.

I guess it must be a combination of IF THEN ELSE with nested VLOOKUP functions. And we have to look for an X that is provided by a function in the cells. So possible some indirect value comparison needen instead of looking for character X in cell.
but i have no clue about how to do it.

Hope someone has the solution.

Very grateful for response.

I can provide the excelsheet via a PM. Seems like i cannot attach it to this post

Best regards,
Mike