offset nesting

[usrepat]

i am getting an error for following:

=average(offset(VLOOKUP(A186,A7:V1288,B4),-10,0):b1268)


should be ok...any help

thanks

 

[Luke M]

The first arguement of OFFSET requires a reference and your VLOOKUP is
outputting a value. How about this:

=AVERAGE(OFFSET(A6,MATCH(A186,A7:A1288)-10,B4):B1268)