具有两个条件的Excel查找公式 [英] Excel Lookup Formula with Two Conditions

问题描述

这是我的问题
我有3个单元格：贷款人，产品和产品ID我有一个vlookup，填补了贷款人和产品细胞只是罚款
但我想要一种方法从另一个与贷款人和产品匹配的工作表返回产品ID。

例如，如果call1 = newcastle和cell2 = 2年固定，那么cell3 = 422

我尝试使用vlookup，但似乎没有工作，任何帮助将不胜感激。谢谢

解决方案

使用MATCH和INDEX函数的组合的另一个替代方法是，有些人可能会发现更简单的是先插入一列您的查找表并连接您要搜索的列的cobmination。

= CONCATENATE（B8，C8）

然后，您仍然可以使用Vlookup功能，输入一列进行查找，您将在查找中组合它们，以便它们的组合在查找表上查找它们的组合。

= VLOOKUP （B3& C3，A9：D10,4,0）

Sorry about the heading but im finding it hard to explain so ill give it my best shot.

Here is my problem I have 3 cells: Lender, product and productID I have a vlookup that fills the lender and product cells just fine However i want a way to bring back the productID back from another worksheet matching with lender and product.

For instance if call1 = newcastle and cell2 = 2 year fixed then cell3 = 422

I tried using a vlookup but doesnt seem to work, Any help on this would be greatly appreciated. Thanks

解决方案

Another alternative to using combination of the MATCH and INDEX functions that some may find more straightforward is to first insert a column on your lookup table and concatenate the cobmination of columns you wish to search by.

=CONCATENATE(B8,C8)

Then you can still use the Vlookup function, but instead of only entering the one column to lookup on, you would combined them in the lookup so that the combination of them looks up to the combination of them on the lookup table.

=VLOOKUP(B3&C3,A9:D10,4,0)

这篇关于具有两个条件的Excel查找公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！