excel如何在平台列输入文字后,费率列自动输入对应的费率,比如我在平台列输入了中行,对应的费率列自动输入0.70%
用一个常见的vlookup就可以解决了
费率这列输入公式后下拉填充即可
=VLOOKUP(F2,{"金控",0.0055;"海科",0.006;"中行",0.007;"交行",0.008},2,0)