offset nesting

  • Thread starter Thread starter usrepat
  • Start date Start date
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
 
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)
 
Back
Top