Index-Match help

[Jason24]

I have a list of data I'm trying to use in a dashboard, and I'm having trouble writing the formula.

Column A is the "category" the data falls under and Columb B is the Employee that the row relates to. For example:

Column A
Total
Total
Ranking
Ranking
Average
Average
+/-
+/-

Column B
Jason
Kacie
Jason
Kacie
Jason
Kacie
Jason
Kacie

All of the data has one unified header (I had originally seperated it into 5 seperate tables, however I was 100% lost on how to determine which array to use, and figured it would be easier to just group it all together since you wont be using those lists to review the data anyway). So, my column lables are:

A1-U1
Total Name Policy Attitude Punctuality Studious Etc.

I want to be able to have a forumla that returns the value in the array that checks to see if Column A and Column B are a specific value using a validation list, and then returns the value from the column that matches data in a third validation list...

It is attached.

I know this sounds really, really confusing, that's why I haven't been able to just google my answer like normal, because I don't even know how to explain what I'm trying to accomplish simply.