寻找价值 [英] 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屋！
查看全文
