Finding average of a VLOOKUP range

New Contributor

I am trying to create a formula to average the range of a vlookup. So in the below example the Price should reflect an average between the Start Date and the End Date, which should update as those dates change. 


I tried the following formula which did not work:



01-Jan	3000			
02-Jan	4000		Start Date	03-Jan
03-Jan	5000		End Date	07-Jan
04-Jan	6000			
05-Jan	7000		Price	
06-Jan	8000			
07-Jan	9000			
08-Jan	10000			
09-Jan	11000			
10-Jan	12000			


Any thoughts?

2 Replies
best response confirmed by viccart (New Contributor)



You can try this formula.

finding average of range.JPG


Perfect thank you!