索引＆amp;符合多个标准
我一直在努力弄清楚我
在这里做错了什么的解释：
- 这是客户需要猜测4个条件的游戏（服装，品牌，颜色，价格，价格）
- 我必须在两个工作表之间匹配，这是客户的猜测和列表（这是标准），
- 它将仅显示2个结果（ bingo，再试一次在黄色列中），
- 标准是猜测< em>服装，品牌，颜色需要正确正确（如列表工作表中所示）
- price 它可以是其他值，但不少于/超过5个
=IF(ABS(INDEX(list!D:D,MATCH(A2,list!A:A,0),MATCH(B2,list!B:B,0),MATCH(C2,list!C:C,0))-D2)<=5,"bingo",IF(ABS(INDEX(list!F:F,MATCH(A2,list!A:A,0),MATCH(B2,list!B:B,0),MATCH(C2,list!E:E,0))-D2)<=5,"bingo","try again"))
- ，上面是公式我使用的是，但是结果错误
- 如果正确执行的结果，则结果就像在 yelld linte
- 注释列和橙色亮点不涉及它只是仅仅是可选的说明，您可以理解
列表
I have been trying to figure it out for what I was doing wrong
Here the explanation for what I am currently doing :
- It is a game that customer need to guess for 4 condition (outfit,brand,color,price)
- I have to match between 2 worksheets which is customer's guessing and list (which is criteria)
- it going to show only 2 result (bingo,try again like in yellow column)
- the criteria is guessing for outfit,brand,color need to be exactly correct (as shown in list-worksheet)
- for price it can be the other values but not less/more than 5
=IF(ABS(INDEX(list!D:D,MATCH(A2,list!A:A,0),MATCH(B2,list!B:B,0),MATCH(C2,list!C:C,0))-D2)<=5,"bingo",IF(ABS(INDEX(list!F:F,MATCH(A2,list!A:A,0),MATCH(B2,list!B:B,0),MATCH(C2,list!E:E,0))-D2)<=5,"bingo","try again"))
- the above is formula that I use but it turned out error
- if doing correctly the result would be like in yellow column
- Note column and orange highlights does not involve it's just optional explanation for your understanding
list
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
因此，您遇到问题的主要原因是因为您的
list工作表被严重设置。 Excel使用扁平文件类型的数据结构运行最佳。应该对此进行重新格式化：然后您可以设置猜测游戏并使用简单的sumifs公式：
在猜测游戏工作表的单元格E2中，公式为：
So the main reason you're running into issues is because your
listworksheet is setup terribly. Excel runs best with a flat-file type data structure. It should be reformatted to this:Then you can setup your guessing game and use a simple SUMIFS formula:
In cell E2 of the guessing game worksheet, the formula is: