Creating Vlookup formula to aveage between two dates

**MROMAR** · 06-13-2012, 04:17 PM

So I'm attempting to do a vlookup that averages all the values between two dates.

On Sheet 1 in A1 I have June 1 2012 and A4 I have June 5 2012. In another sheet I have the dates June 1-30 in cells A5-A35 with the data in cells B5-B35 corresponding with the date.

I need help creating a formula that would do a vlookup of all values between June 1 and June 5 or whatever dates I put into A1 and A4 on Sheet 1, so that it would look up the B column values in Sheet 2 of June1-5 and average them out.

I was currently doing it for one day using the formula =VLOOKUP($A$1,WEST!$A$5:$M$35,3,FALSE) but I need to do a month to date value.

Any suggestions?

**Cutter** · 06-13-2012, 04:26 PM

Have a look at the AVERAGEIFS() function.

http://www.excelfunctions.net/Excel-...-Function.html

**medo82006** · 05-17-2013, 11:04 PM

When using Vlookup
Example:

A B
1 5
2 6
3 7
4 8
5 9

If I use vlookup (2.7,a,2,true) I get 6 or 7.
i need get the average between 6 and 7 (i.e. (6+7)/2=6.5)
Can this be done?

Thank you.

**arlu1201** · 05-18-2013, 02:56 AM

medo,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.