寻找给出最低价格的最低供应商 [英] To find the lowest supplier who gives the lowest price
问题描述
我有一张纸给出了两个供应商中最低的价格.这个平台的一位成员帮助我找到了价格最低的供应商.但问题是,只有两个条形码都位于同一行时,它才显示该值.请帮助我扩展这个等式,使匹配的条形码出现在表中,这必定会给我最低的供应商.对不起,我的英语不好.以便在这里共享工作表.请看看.
I have a sheet that gives the lowest price among two suppliers. And one member from this platform helped me to find which supplier gives the lowest price. but 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. Am sorry for my bad english. so that the sheet is shared here. Please take a look.
推荐答案
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屋!