How to get the average of multiple VLOOKUP findings

Hey everyone,

I have a questions in regards to the LOOKUP function.

From the table below (it runs all the way through December, this is just an extract) I would like to calculate the average of all 'Mondays' of 'Flight 1' (column C). Then, in the next cell, the avergage of all 'Tuesdays' of 'Flight 1' etc.

I used the following formula:

=AVERAGE(VLOOKUP("mon",B1:H367,2,FALSE))

It does not seem to work as it only picks up on the first value it finds in a particular column, i.e. 95 for the first monday of Flight 1, 100 for the first tuesday of Flight 1 etc.

Is there anyone who knows what's the right formula to use here? Thanks a lot!!

Date Day Flight1 Flight 2 Flight 3 Flight 4

1-Jan Tue 85 95 94 94
2-Jan Wed 97 99 96 95
3-Jan Thu 100 100 97 100
4-Jan Fri 98 100 99 99
5-Jan Sat 99 100 100 94
6-Jan Sun 98 100 96 100
7-Jan Mon 95 100 68 99
8-Jan Tue 100 100 99 100
9-Jan Wed 100 99 97 97
10-Jan Thu 96 99 94 96
11-Jan Fri 100 96 93 93
12-Jan Sat 94 99 79 96
13-Jan Sun 96 92 98 82
14-Jan Mon 100 96 94 94
15-Jan Tue 90 83 90 94
16-Jan Wed 99 81 84 95

Either use this array formula

=AVERAGE(IF(B1:B367="Mon",C1:C367))

which needs to be confirmed with CTRL+SHIFT+ENTER

or

=SUMIF(B1:B367,"Mon",C1:C367)/COUNTIF(B1:B367,"Mon")

Guys,
What if i have names in sheet 1 and each name has a score and the same name has several scores which means that i might have the name repeated, i'd like to make Vlookup in sheet 2 and to get the average of the name of all his scores in sheet 1 in order just to put the name and to reflect with the average of the scores of each name ?????