vlookup then average 3 above and below
I am not very familar with the offset and match functions, but this lookup is
for a series of data that is plotted so there is no blank cells on either
side of the lookup. I am guessing that is what the -4 is? Sorry for being a
pain.
"T. Valko" wrote:
Assuming that there will *always* be 3 cells on either side of the lookup
value:
=AVERAGE(OFFSET(A1,MATCH(1.4,A1:A7,0)-4,,7))
--
Biff
Microsoft Excel MVP
"tpeter" wrote in message
...
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.
|