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