谁能给我简化一下这个EXCEL公式，我快哭了

来源：百度知道 编辑：UC知道 时间：2024/06/25 13:10:13
=IF(COUNTIF(JUX!A2:A29,H3)>0,JUX!B2,(IF(COUNTIF(JUX!C2:C72,H3)>0,JUX!D72,(IF(COUNTIF(JUX!E2:E56,H3)>0,JUX!F56,(IF(COUNTIF(JUX!G2:G36,H3)>0,JUX!H36,(IF(COUNTIF(JUX!I2:I65,H3)>0,JUX!J65,(IF(COUNTIF(JUX!K2:K105,H3)>0,JUX!L105,(IF(COUNTIF(JUX!M2:M167,H3)>0,JUX!N2,(IF(COUNTIF(JUX!O2:O15,H3)>0,JUX!P2,(IF(COUNTIF(JUX!Q2:Q51,H3)>0,JUX!R51,(IF(COUNTIF(JUX!S2:S22,H3)>0,JUX!T2,(IF(COUNTIF(JUX!U2:U24,H3)>0,JUX!V24,(IF(COUNTIF(JUX!W2:W121,H3)>0,JUX!X121,(IF(COUNTIF(JUX!Y2:Y92,H3)>0,JUX!Z2,(IF(COUNTIF(JUX!AA2:AA77,H3)>0,JUX!AB77,(IF(COUNTIF(JUX!AC2:AC30,H3)>0,JUX!AD2,(IF(COUNTIF(JUX!AE2:AE52,H3)>0,JUX!AF52,(IF(COUNTIF(JUX!AG2:AG63,H3)>0,JUX!AH3,(IF(COUNTIF(JUX!AI2:AI56,H3)>0,JUX!AJ56,"无此到站")))))))))))))))))))))))))))))))))))

一个有了到站（火车站），判断此到站是哪个局向的东西

你的函数IF超过八层，公式不成立，但也无法简化（没有规律），可分段：
=IF(COUNTIF(JUX!A2:A29,H3)>0,JUX!B2,IF(COUNTIF(JUX!C2:C72,H3)>0,JUX!D72,IF(COUNTIF(JUX!E2:E56,H3)>0,JUX!F56,IF(COUNTIF(JUX!G2:G36,H3)>0,JUX!H36,IF(COUNTIF(JUX!I2:I65,H3)>0,JUX!J65,IF(COUNTIF(JUX!K2:K105,H3)>0,JUX!L105))))),IF(COUNTIF(JUX!M2:M167,H3)>0,JUX!N2,IF(COUNTIF(JUX!O2:O15,H3)>0,JUX!P2,IF(COUNTIF(JUX!Q2:Q51,H3)>0,JUX!R51,IF(COUNTIF(JUX!S2:S22,H3)>0,JUX!T2,IF(COUNTIF(JUX!U2:U24,H3)>0,JUX!V24,IF(COUNTIF(JUX!W2:W121,H3)>0,JUX!X121))))),IF(COUNTIF(JUX!Y2:Y92,H3)>0,JUX!Z2,IF(COUNTIF(JUX!AA2:AA77,H3)>0,JUX!AB77,IF(COUNTIF(JUX!AC2:AC30,H3)>0,JUX!AD2,IF(COUNTIF(JUX!AE2:AE52,H3)>0,JUX!AF52,IF(COUNTIF(JUX!AG2:AG63,H3)>0,JUX!AH3,IF(COUNTIF(JUX!AI2:AI56,H3)>0,JUX!AJ56,"无此到站")))))))))

这个公式没用的，你的嵌套已经超过了7层。可以列一个对照表，然后用VLOOKUP或者lookup等函数

没有50分不会给你答的,放心吧

没有附件 ，无能为力~

晕啊 ！严重超载！“)))))))))))))))))))))))))))))))))))”

建议你改用VKOOKUP函数吧！因为你的判断数据太多了 ！