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值不显示")