显示哪个供应商给出最低的价格 [英] To display which supplier gives the lowest price

问题描述

我有一张纸给出了两个供应商中最低的价格.问题是，只有两个条形码都位于同一行时，它才显示该值.请帮助我扩展此等式，以便在工作表中匹配的条形码出现时必须给我最低的供应商.供应商列("K")仅在相同的条形码出现在同一行中时才起作用("A"&"C")，例如ABC213是否不在同一行中，因此"K"表示没有价值.我在那里应用了一个公式.因此，如果您可以对其进行修改，那将对我有很大帮助

I have a sheet that gives the lowest price among two suppliers. the problem is it displays the value only if both barcode comes in the same row. pls help me to expand this equation that where ever matching barcode comes in the sheet must give me the lowest supplier.supplier column ("K") works only if the same barcode comes in same row ("A" & "C") an eg is there ABC213 are not in same row, so "K" doesnt give value. i have applied a formula there. so if u can modify it that would be a great help for me

推荐答案

要获取最低价格，您可以使用

To get lowest price you can use MIN(), example =MIN(B2, D2) :

对于 K2 ，您已经具有适用的公式

For the K2 you already have the formula which works well

=INDEX(A$1:D$1,match(J2,A2:D2,0)-1)

现在您选择单元格J2 + K2，然后向下拖动以将其展开.

And now you select cells J2 + K2 and just drag down to expand it.

这篇关于显示哪个供应商给出最低的价格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！