How to average multiple vlookup findings in Excel? For example there are many values matched the lookup value in your table, and you want to average all vlookup findings (target values) in Excel, how could you calculate the average quickly?
May 23, 2017 · In the next article, we will discuss a couple of formulas find weighted average in Excel and you might be surprised to know that it's much easier than it sounds. I thank you for reading and hope to see you on our blog next week! You may also be interested in: How to calculate weighted average in Excel; How to calculate moving average in Excel Because your data set has a large number of items with a finite number of values. Because the value you are trying to calculate is made up of categories which each have different weights. Using the attached tableau workbook – is there a way to calculate the weighted average life of the dollars? I would think of this in Excel terms as: Sumproduct(Period Index * Dollars)/Sum(Dollars)/12 I get the message “cannot mix aggregate and non aggregate arguments to function” when trying to set this up in “Sumproduct”.