查價 找調價前或後的成本價 (14057)

AI2{=RIGHT(MAX(IF((Y$2:Y$9=AF2)*(Z$2:Z$9=AG2),-1^(AB$2:AB$9>AH2)*(AB$2:AB$9/1%%+N(OFFSET(AA$1,ROW($1:$8),(AB$2:AB$9<AH2)*2))))),4)*1