Re: Average over a text range using a vlookup In Column

Hi,

i would like to calculate the average of these text field, so i have created another table for vlookup. as i look through other people comment i've managed to test how it work horizontally (the look up value are the same row) but i have a much bigger one where the lookup value are shown vertically lookup (value are in different cell in one column.)

please see attachment for detail

B1: =VLOOKUP(A1,'grade Sheet'!A:B,2,FALSE) and fill down

Average: =AVERAGE(B1:B8)

thanks it worked

You're welcome. Thanks for the feedback.