excel交叉查询(查表)

方法1：=IFERROR(INDEX($B$4:$O$17,MATCH(C21,$A$4:$A$17,0),MATCH(B21,$B$3:$O$3,0)),"")方法2（欢乐小爪提供）：=OFFSET($A$3,MATCH(C21,$A$4:$A$17,0),MATCH(B21,$B$3:$O$3,0))