交叉查詢 二文本數字 (9444)

AE5{=OFFSET(B4,MATCH(AC5,IFERROR(LEFTB(B5:B20,2)*1,LEFT(B5:B20))*1),MATCH(AD5,IFERROR(LEFTB(C3:AA3,2)*1,LEFT(C3:AA3))*1))

另解{=INDEX($C$5:$AA$20,MATCH(AC5,--LEFTB(SUBSTITUTE(B5:B20,"-"," "),2)),IFERROR(MATCH(AD5,--LEFTB(SUBSTITUTE(C3:AA3,"-","  "),2)),1))