我正在尝试基于2个单元格值生成某些列表。例如,如果x=45和y=70生成列表。这是我提出的公式,但它太长了,无法放入数据验证源中。有没有一种更简单的方法可以让我做到这一点?
=IF(AND($K$23 ="Capital Area", $L$23="Vodafone4G"), CAVodafone4G, IF(AND($K$23 ="Capital Area", $L$23 = "Vodafone5G"), CAVodafone5G, IF(AND($K$23 ="Capital Area", $L$23 = "Optus4G"),CAOptus4G, IF(AND($K$23 ="Capital Area", $L$23 = "Optus5G"),CAOptus5G, IF(AND($K$23 ="Capital Area", $L$23 = "Telstra4G"), CATelstra4G, IF(AND($K$23 ="Capital Area", $L$23 = "Telstra5G"), CATeltra5G, IF(AND($K$23 ="Regional Area", $L$23="Vodafone4G"), RAVodafone4G, IF(AND($K$23 ="Regional Area", $L$23 = "Vodafone5G"), RAVodafone5G, IF(AND($K$23 ="Regional Area", $L$23 = "Optus4G"),RAOptus4G, IF(AND($K$23 ="Regional Area", $L$23 = "Optus5G"),RAOPtus5G, IF(AND($K$23 ="Regional Area", $L$23 = "Telstra4G"), RATelstra4G, IF(AND($K$23 ="Regional Area", $L$23 = "Telstra5G"), RATeltra5G))))))))))))
请帮忙哈哈:(
感谢
之类的东西怎么样
=IF($K$23 ="Capital Area";"CA";if($K$23 = "Regional Area";"RA"))&$L$23
您只需要两个条件,其余的只是串联。