i am getting an error for following: =average(offset(VLOOKUP(A186,A7:V1288,B4),-10,0):b1268) should be ok...any help thanks