offset nesting

U

usrepat

i am getting an error for following:

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


should be ok...any help

thanks
 
L

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)
 
Top