Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
retrieve an AVERAGE of a range using VLOOKUP to locate start/end d
2 views
Skip to first unread message
Sol
Nov 23, 2009, 6:49:01 PM11/23/09
to
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?
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?
Barb Reinhardt
Nov 23, 2009, 9:29:01 PM11/23/09
to
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.
--
HTH,
me, I'd probably enter the formula manually, record the result from there and
put that in my code.
--
HTH,
Barb Reinhardt
0 new messages