Ok, so I'm back for some more.
This time I'm looking to take the Average of a range of cells, based on a vlookup from a separate table/sheet.
Table2.png
In the image, for cell C5 and down, I want to VLOOKUP the value of the corresponding column D reference against Table 2 and take the average of the row that the VLOOKUP finds from column H through K.
Any ideas oh guru's of Excel?
Bookmarks