Forum Discussion
Solved
Finding average of a VLOOKUP range
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 da...
=AVERAGE(INDEX($B$1:$B$10,MATCH($E$2,$A$1:$A$10,0)):INDEX($B$1:$B$10,MATCH($E$3,$A$1:$A$10,0)))You can try this formula.
=AVERAGE(INDEX($B$1:$B$10,MATCH($E$2,$A$1:$A$10,0)):INDEX($B$1:$B$10,MATCH($E$3,$A$1:$A$10,0)))You can try this formula.
Perfect thank you!