UC知道一些关于excel的傻瓜问题六
来源：百度知道 编辑：UC知道 时间：2024/06/17 21:19:54
表中，A1=木，A2= （空白），A3=火，A4=土，A5=金，A6=水，A7=木……………………自动对应B1B2B3B4B5B6填入“黄”“绿”“蓝”“红”“灰”，金为黄，木为绿，水为蓝，火为红，土为灰。像A2为空白的，B2也不填入任何值，留为空白。
=IF(A1="","",VLOOKUP(A1,{"金","黄";"木","绿";"水","蓝";"火","红";"土","灰"},2,))
或者
=IF(A1="","",LOOKUP(A1,{"火","金","木","水","土";"红","黄","绿","蓝","灰"}))
或者
=CHOOSE(FIND(A1," 火金木水土"),"","红","黄","绿","蓝","灰")
=IF(TRIM(A1)="","",IF(TRIM(A1)="金","黄",IF(TRIM(A1)="木","绿",IF(TRIM(A1)="水","蓝",IF(TRIM(A1)="火","红",IF(TRIM(A1)="土","灰",""))))))
可能有些复杂，但我只知道这个方法。呵呵。