Help with averages and vlookup

Hello,
I'm trying to average a range of values within a given date range. I was attempting to use vlookup, but I'm not sure what the missing step for the averaging part is. Here is the formula I'm using so far (but it only returns one value, of course):

=VLOOKUP(AH13,$F$6:$S$3693,14)

The dates are in column F and the values are in column S. There are multiple entries for every date that I want to average into a simple table that will display daily averages. The dates have been validated into AG12 and a little table made beside it at AH13:AN14 with dates on top and the return values underneath. So far everything works okay, except it will only return one number instead of an average of all the numbers on that date (of course). This is a dynamic chart that should be able to look up any day in the year and return a full week of averages, so it wouldn't be useful to put an actual hard date range into the formula, I don't think.

Any help on this issue would be greatly appreciated.

Thank you,
Maralita

I haven't tried the pivot table, but I did try AVERAGEIF() with no success. I don't think I typed it out correctly. Do you have a formula sample I could try?

okay, I'll try that. Thank you.

Yes! I do believe you've solved it! thank you very much. That was much simpler than I had made it out to be.