202001201531二項組合 找對應位置 (6504)

H2:H8{=IF(OFFSET(B2,,H$1-23),VLOOKUP(A2&OFFSET(B2,,H$1-23),IF({1,0},A$12:A$20&OFFSET(B$12,,H$1-23,9),H$12:H$20),2,),"")

方式二=IF(OFFSET(B2,,H$1-23),LOOKUP(,0/(A$12:A$20&OFFSET(B$12:B$20,,H$1-23)=A2&OFFSET(B2,,H$1-23)),H$12:H$20),"")

方式三=IF(OFFSET(B2,,H$1-23),LOOKUP(1,0/(A2=A$12:A$20)/(OFFSET(B2,,H$1-23)=OFFSET(B$12,,H$1-23,9)),H$12:H$20),"")

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank





Powered by Xuite