excel表如何把表2的内容引用到表1

2025-06-21 10:32:33
推荐回答(1个)
回答1:

B6=IF($A6="","",HLOOKUP(B$5,OFFSET(Sheet2!$C$5,,MATCH(LOOKUP("座",$B$4:$B$4),Sheet2!$C$4:$Z$4,)-1,99,12),MATCH($A6,Sheet2!$A$5:$A$99,),))

右拉下拉

(设定"0值不显示")