How to return values based on row and column name Excel

Question

I am needing help to return values from a table based on certain criteria. I have a sheet that returns agent names based on the selected Skill Group name (ie. Member or Provider) but I am needing to also return what skill priority those agents have based on the specific skills the agents are assigned. On the main sheet I have it setup so when you select a skill group (ie. Member) it returns the agents associated to that skill group and the specific skills associated to that skill group. I am struggling with how to return the skill priority level based on the agent names and specific skill names.

The first table below is my data table with the agent names, skill names, and skill priority levels. The Second table below is what the return table should ideally look like. The return table is based on when the skill group is selected it displays the agents that are associated to that skill group and displays the specific skills associated to the skill group.

To summarize, I am needing help on how to return the skill priority levels based on the agent names and the specific skill names. The agent names and specific skill names will change based on the skill group that is selected. I hope this is clear and if I need to provide more info or be a bit more clear about something please let me know.

|Agent Skill Priority Table|

Agent Names	Skill 1	Skill 2	Skill 3	Skill 4	Skill 5
Name 1	1	2	3
Name 2		1	2
Name 3	3	3	3
Name 4	1			5	5
Name 5	1			5	5
Name 6	5		3	3	3
Name 7	5	1	2		3

|Ideal Return Table|

Agent Names	Skill 2	Skill 3	Skill 5
Name 1	2	3
Name 2	1	2
Name 3	3	3
Name 4			5
Name 5			5
Name 6		3	3
Name 7	1	2	3