C23公式:=IF(ISNA(LOOKUP(2,1/(($K$13:$K$22"无")*($K$13:$K$22"")),$J13:$J22)),IF(ISNA(LOOKUP(2,1/(($G$13:$G$22"无")*($G$13:$G$22"")),$F13:$F22)),LOOKUP(2,1/(($C$13:$C$22"无")*($C$13:$C$22"")),$B13:$B22),LOOKUP(2,1/(($G$13:$G$22"无")*($G$13:$G$22"")),$F13:$F22)),LOOKUP(2,1/(($K$13:$K$22"无")*($K$13:$K$22"")),$J13:$J2... |