查表 多條件立體數據 (14092)

E4:G6{=OFFSET(J$4,MATCH(1,(EOMONTH($B4,-1)+1=$I$5:$I$13)*($J$5:$J$13=$C4),),MATCH($D4,$K$3:$S$3,))&""

另解=LOOKUP(1,0/($I$5:$I$13&$J$5:$J$13=EOMONTH($B4,-1)+1&$C4),OFFSET(J$5:J$13,,MATCH($D4,$K$3:$S$3,)))&""