举报
T_T 发表于 2021-1-7 18:26 =IF(VLOOKUP(B2&C2,A:C,3,0)="绿","绿",IF(VLOOKUP(B2&C2,A:C,3,0)="黄","黄","红")) 加一个辅助列 把1 ...
本版积分规则 发表回复 回帖后跳转到最后一页
Archiver|手机版|小黑屋|MJJ论坛
Copyright MJJ论坛 © 2022 All Rights Reserved.