I have data arranged in a matrix as follows:

Cells A2:A12

__TEAM__

Global

Local

Documentation

Local

Local

Global

Documentation

Global

Global

Global

Cells B2:B12

__SCORE__

1

4

2

3

3

3

4

5

2

2

Cells B1:F1

Task 1

Task 2

Task 3

Task 4

Task 5

I have a drop down list with the teams listed (Global, Local, Documentation)

The idea is that users select a team and get to see that team's scores for the tasks in question. So I need a formula that will search for the team name displayed in the drop down list, add up the total scores applicable to that team and then return the average so as I have an overall team score (the idea is that the team names listed in cells A2:A12 are associated with a list of individuals, listed in another column, hence why some are repeated)

The formula will need to be some form of VLOOKUP or INDEX/MATCH combo as, for each cell its entered into, it needs to return the correct value relevant to the tasks shown in cells B1:F1

I hope the above makes sense and that someone can help.

Thanks

James