retrieve an AVERAGE of a range using VLOOKUP to locate start/end d

S

Sol

Can I calculate the average of a range based on VLOOKUP? In other words, can
I get Excel to "look up" the respective START / END dates of an investment
position listed in Sheet 1 and then go and locate those 2 distinct cell
values in in a different sheet (Sheet 2) utilizing VLOOKUP function and then
return the calculated AVERAGE of the cells within that range back into Sheet
1?
Appreciate any thoughts if doable in Excel in any way?
 
B

Barb Reinhardt

tAKE A LOOK AT AverageIFS and see if that does what you want. If it were
me, I'd probably enter the formula manually, record the result from there and
put that in my code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the VLOOKUP function to find an Average 2
For Each Cell in Sheet1 Range, do some Vlookup calc. from Sheet3 5
Insert text in column A and calculate the average from column B 4
Vlookup in vba - how to use absolute rows not relative 1
Average of cells from a table given certain criteria 2
Best way to run Find or Vlookup down specific column in range 2
using vlookup in a loop 2
need help doing a vlookup and average 7

Top