这函数感觉写复杂了，有没有大神有简单点的公式阿！

TRIM(LEFT(TEXTJOIN(" ",1,IFERROR(IF(FIND({"液位","温度","夹套","压力","电流"},D6),{"0","0","0","-100","0"},""),"")),5))

VLOOKUP(1,IF({1,0},{1,2,3},{44,55,66}),2,0)，这个值怎么是55呢，晕了

VLOOKUP(1,IF({1,0},COUNTIF(D6,"*"&{"液位";"温度";"夹套";"压力";"电流"}&"*"),{"0";"0";"0";"-100";"0"}),2,0)

lookup+find

好久没这样用了，解释下siaojun哥：=VLOOKUP(1,IF({1,0},{1;2;3},{44;55;66}),2,0)