Using Average with VLOOKUP (maybe HLOOKUP) Help

**michutch** · 08-22-2012, 11:30 AM

Hello,

I am trying to get the weighted average of values in several rows of a column in which there are several matches in the lookup column. For example, column A has price and column B has returns. If column A has four rows with the same price, I need to get the weighted average of the corresponding returns in column B. Here is a test formlua that I got to work with values across multiple columns, but cannot figure out how to get it to work across multiple rows.

=AVERAGE(VLOOKUP($D$2,$A$2:$C$8,{2,3},FALSE))

Any help would be greatly appreciated.

Thanks

**NBVC** · 08-22-2012, 11:37 AM

=AVERAGEIF(A2:A8,D2,B2:B8) gives average of column B where column A equals D2. Is that what you mean?

**michutch** · 08-22-2012, 12:53 PM

Yes - thanks. And that was beautifully simple.

**michutch** · 08-22-2012, 01:15 PM

Sorry - quick follow-up. How could I modify this to allow for a weighted average vs. straight average? So, aside from Price and Return, I would have a third column for volume which could impact the weighted average return.

Thanks!