excel - EXCEL：根据满足的 2 个条件从表中返回 1 个值

Question

我有一张按单位数量和按国家/地区划分的运费表。一旦在订单的其他地方填写了瓶子的数量和国家/地区，我希望总运费出现在我的订单上。关于什么公式可以做到这一点的任何想法？

Here's a small part of my table:
           1           2           3          4             5         6
France   €12.60      €14.40      €17.40      €19.44      €21.36      €23.40 
Belgium  €20.40      €26.40      €31.20      €36.60      €42.00      €46.80 
Germany  €20.40      €26.40      €31.20      €36.60      €42.00      €46.80 

So for the client shipping to Germany that selects 5 units, how do I get €42.00 to appear in the shipping cost cell?

Thank you

标签： excelexcel-formula

Answer 1

带有两个 MATCH 的 INDEX。

=INDEX(A1:G4,MATCH("Germany",$A$1:$A$4,0),MATCH(5,$A$1:$G$1,0))