EXCEL 当一个单元格满足多个条件时,对应单元格跳特定值?答:=VLOOKUP(A1,{"放弃账户","永久黑名单";"失效44天","永久黑名单";"账户退款","永久黑名单";"账户违规被拒","永久黑名单";"客户表示不让跟进","短期黑名单";"客户短期内无推广计划","短期黑名单"},2,0)
Excel 自动返回满足2个条件的对应值,如图Sheet1中需要填入的公式...答:在SHEET1的B2中输入或复制粘贴下列公式 =VLOOKUP($A2,Sheet2!$A:$G,MATCH(B$1,Sheet2!$1:$1,),)或 =INDEX(Sheet2!B$2:G$100,MATCH($A2,Sheet2!A$2:A$100,),MATCH(B$1,Sheet2!B$1:G$1,))下拉填充,右拉填充
Excel在空白单元格符合多个条件后显示指定文本数据?答:在 Excel 2007 中,可以用以下公式满足题述要求:1. 非数组公式:=IF(B2>110,IF(D2<=9%,"不置休",IF(AND(D2>9%,D2<=18%),"2小时",IF(AND(D2>18%,D2<=30%),"4小时",IF(AND(D2>30%,D2<=100%),"6小时",""))),IF(C2<=7,"不置休",IF(AND(C2>7,C2<=12),"2小...