首页 \ 问答 \ Excel VLOOKUP 3列(Excel VLOOKUP for 3 columns)

Excel VLOOKUP 3列(Excel VLOOKUP for 3 columns)

 我将在我的xls文件中使用VLOOKUP 3列。 以下是参考表格： 
 

Building     |    Floor    |     Location ID
----------------------------------------------
Building A   | 1           | 1001
Building A   | 2           | 1002
Building B   | Ground      | 2000

 

 我应该如何为这种情况编写VLOOKUP公式？ 这样我可以使用Building和Floor列作为LOOKUP VALUE和Location ID作为RESULT ？ 谢谢。 

I'm going to use the VLOOKUP for 3 columns in my xls file. Below is the reference table :
 

Building     |    Floor    |     Location ID
----------------------------------------------
Building A   | 1           | 1001
Building A   | 2           | 1002
Building B   | Ground      | 2000

 

How should I write the VLOOKUP formula for this case ? So that I can use the Building and Floor columns as the LOOKUP VALUE and the Location ID as the RESULT ? Thx.

原文：https://stackoverflow.com/questions/7950723
更新时间：2023-10-21 21:10

最满意答案

 我自己找到了： 
 

string Command = "INSERT INTO [" + variable + "]  VALUES ('" + _ID + "','" + txt1.Text + "') ";
Connection(Command);

 

 你应该删除变量周围的引号!!!! 

I found it myself:
 

string Command = "INSERT INTO [" + variable + "]  VALUES ('" + _ID + "','" + txt1.Text + "') ";
Connection(Command);

 

you should remove quotation mark around of variable!!!!

相关问答

更多