[已解决]在选择文字对应的数值

229721120@qq.co

表.rar (18.09 KB, 下载次数: 4)

2013-10-22 18:47 上传

点击文件名下载附件 各位高手，lookup函数是否有限制呢！我附件做的，好像不成功。麻烦高手指点下。

最佳答案

月排行榜 / 总排行榜

suye1010

2013-10-22 19:55

1. =TEXT(SUMPRODUCT(N({"咀嚼片","益生菌胶囊","妈妈400","呵护1段","呵护2段","呵护3段","呵护4段","妈妈900","DHA咀嚼丸","金装1段","金装2段","金装3段","金装4段","素加0段","素加1段","素加2段","素加3段","素加4段","益生菌26","超金1段","超金2段","超金3段","超金4段","益生菌48","益生菌60"}=A2),{30,70,90,130,130,130,130,170,180,180,180,180,180,260,260,260,260,260,220,250,250,250,250,420,540}),"0;;;")

复制代码

跳转到最佳答案楼层

蝶·舞

第一参数升序的要求

suye1010

1. =TEXT(SUMPRODUCT(N({"咀嚼片","益生菌胶囊","妈妈400","呵护1段","呵护2段","呵护3段","呵护4段","妈妈900","DHA咀嚼丸","金装1段","金装2段","金装3段","金装4段","素加0段","素加1段","素加2段","素加3段","素加4段","益生菌26","超金1段","超金2段","超金3段","超金4段","益生菌48","益生菌60"}=A2),{30,70,90,130,130,130,130,170,180,180,180,180,180,260,260,260,260,260,220,250,250,250,250,420,540}),"0;;;")

复制代码

229721120@qq.co

suye1010 发表于 2013-10-22 19:55

版主：N是什么作用的。麻烦解释下可以吗？