I have 2 colums of data and my vlookup works fine, but I now want it to find
the value, take the previous 3 data points and the next 3 data points and
give me the average of these 7 data points. I think the vlookup is the
correct function but I am not sure. her is an example

1 1.1
2 1.2
3 1.3
4 1.4
5 1.5
6 1.7
7 1.8

so if my vlookup found the value of 1.4, I want it to average
1.1,1.2,1.3,1.4,1.5,1.6,1.7, and 1.8 and return that value.

Thank you for any help.