excel里面,如果A列=a, B列显示“大”,如果A列=b,B列显示“中”,如果A...答:1、=IF(A5<>"",LOOKUP(A5,{,"a","b","c"},{,"大","中","小"}),"")但这个有一个缺点,如果 LOOKUP 找不到 lookup_value,则它与 lookup_vector 中小于或等于 lookup_value 的最大值匹配。2、=IF(A1="A","大",IF(A1="b","",IF(A1="c","小",""))) 这个百分百正确 ...
求电子表格公式有A、B、C列要求当A=B时D=C,如A1=B3则D1=C3,在线等,速...答:D1输入公式:=VLOOKUP(A1,B:C,2,0)下拉复制公式。找不能时显示空值,公式:=IF(ISERROR(VLOOKUP(A1,B:C,2,0)),"",VLOOKUP(A1,B:C,2,0))