Employee/Candidate <> Role/Company Match

[iwill]

Hi guys,
In the last few days I've been doing an internal assessment of the skills needed by certain companies that we working for, but also the skills that my employees have.
With that, I started to create a kind of database in which:
the first sheet has the necessary technologies to ensure in each company needs;

hard_skills_por_cliente.xlsx
	A	B	C	D		F	G	H	I	J
3	Role	Vendor	Technologies Type	Technologies / Services		COMPANY 1	COMPANY 2	COMPANY 3	COMPANY 4	COMPANY 5
4	System Administrator	Veeam	Backup	Veeam Backup & Replication		X	X
5	System Administrator	Micro Focus	Backup	Data Protector		X
6	System Administrator	Commvault	Backup	Commvault				X
7	System Administrator	Veritas	Backup	Enterprise Vault			X
8	Network Administrator	Veritas	Backup	Backup Exec			X
9	System Administrator	Veritas	Backup	NetBackup						X
10	Network Administrator	Cisco	Certificate	CCNA		X
11	Network Administrator	Fortinet	Certificate	NSE 4		X
Client <> Tech

the second sheet has the collaborators, the position they currently occupy and the company they work for, as well as the technologies they know;

hard_skills_por_cliente.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Employee	Role	Company	Veeam Backup & Replication	Data Protector	Commvault	Enterprise Vault	Backup Exec	NetBackup	CCNA	NSE 4
2	John Meyer	Team Leader	COMPANY 1
3	Helen Silva	Network Administrator	COMPANY 3	x				x
4	Thomas Heys	Field Support Technician	COMPANY 2	x	x
5	William Navy	System Administrator	COMPANY 1		x	x
6	Henry Tubb	System Administrator	COMPANY 3				x	x	x
7	Andrew Phillips	System Administrator	COMPANY 4		x	x	x	x
Employees <> Tech

the third sheet reflects the technologies needed for each role in each company

hard_skills_por_cliente.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Role	Company	Veeam Backup & Replication	Data Protector	Commvault	Enterprise Vault	Backup Exec	NetBackup	CCNA	NSE 4
2	System Administrator	COMPANY 1	X	X
3	Network Administrator	COMPANY 1							X	X
4	System Administrator	COMPANY 2	X			X
5	Network Administrator	COMPANY 2					X
6	System Administrator	COMPANY 3
7	Network Administrator	COMPANY 3
Cliente Roles <> Tech

Cell Formulas
Range	Formula
C2:J3	C2	=IFNA(VLOOKUP($A2&C$1,'Client <> Tech'!$E$4:$V$79,2,0),"")
C4:J5	C4	=IFNA(VLOOKUP($A4&C$1,'Client <> Tech'!$E$4:$V$79,3,0),"")
C6:J7	C6	=IFNA(VLOOKUP($A6&C$1,'Client <> Tech'!$E$4:$V$79,5,0),"")

My goal, which i cannot see how to do it is: Have a sheet which shows me the compatibility (percentage) of a certain employee with a certain role in the various companies.