Tech Support Forum banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter · #1 ·
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? Ultimately, I need to calculate the AVERAGE of the all the cell values within that Defined RANGE and return it back into Sheet 1?
Appreciate any thoughts if doable in Excel in any way?
 

·
Folding Along
Joined
·
2,304 Posts
You can probably create a macro to do it in one step, but I'm not real good at macros.

I would use VLOOKUP to create a list of the data I want then apply AVERAGE to that list.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top