表列取值 (11953)

B8=IFERROR(LOOKUP(9^9,OFFSET(M1,,,MATCH(A5,L:L,),)),"XX")

B13:B17=IFERROR(IF(A$2="工具機",OFFSET(N$1,MATCH(C13,M:M,)+MATCH(A$5,L$11:L$21,)-2,),""),"XX")