找到值 [英] to find the values
本文介绍了找到值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我们有更多的供应商提供相同的产品(条形码)时,我需要找出哪个供应商的价格最低.我有很多供应商,他们提供相同的产品.在这种情况下,我需要找出谁给了我最低的价格,而无需手动查找.@Kirkg13 先生给了我一个解决方案,在最新的价格中找出最低的价格.现在我想显示谁给出的最低价格 当我们输入所有供应商通用的条形码时.
I need to find out Which supplier gives the lowest price When we have more suppliers giving the same product (Barcode). I have so many suppliers and they supply the same product. in that case i need to find out who give me the lowest price without manual lookup. Mr. @Kirkg13 gave me a solution to find out the lowest price among the latest price. Now i want to display Who gives the lowest price When we enter a barcode which is common in all suppliers.
推荐答案
尝试:
=ARRAYFORMULA(IFNA(VLOOKUP(J2:J&K2:K,
SORT(SPLIT({A2:A&B2:B&"♦"&A1; C2:C&D2:D&"♦"&C1}, "♦"), 2, 1), 2, 0)))
这篇关于找到值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文