| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
retrieve an AVERAGE of a range using VLOOKUP to locate start/end d
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
retrieve an AVERAGE of a range using VLOOKUP to locate start/end d
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, Barb Reinhardt "Sol" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VLOOKUP to locate an answer in one of multiple columns | Excel Worksheet Functions | |||
| How to start recording a Macro & Retrieve the contents via Atomati | Excel Programming | |||
| using the formula Average(start:end!b4) | Excel Discussion (Misc queries) | |||
| How can I locate the second to last value in a range? | Excel Worksheet Functions | |||
| Cntrl find - cannot locate zip codes that start with zero. Possibl | Excel Discussion (Misc queries) | |||
Linear Mode
