Excel Vlookup多列 [英] Excel Vlookup multi column
问题描述
像我这样的上师，我受命解决一些问题，但我做不到！
有一个工作表要求在列中查找表值.
它是这种格式...
Col A-Col B-Vlookup()
列Vlookup()所在的表的格式为...
A栏-B栏-C栏
A列保留我希望在第一张工作表的第三列中输入的值.
但是！
通常这很容易，但在这种情况下，我需要使用2列进行查找和比较.
怎么样?
我已经尝试了Vlookup(A1&B1，[Datatable]，1，T)，但是它不起作用.
Guru as I am, I have been tasked with solving something, and I can''t!
There is a sheet that requires look-up table values in a column.
It is in this format...
Col A - Col B - Vlookup()
The sheet the data for Column Vlookup() is in is in the format...
Col A - Col B - Col C
Column A holds the value I wish to put into the third column of the first sheet.
HOWEVER!
Whilst normally this would be easy, in this case I need to use 2 columns for the look up and the compare.
How?
I have tried Vlookup(A1&B1,[Datatable],1,T) but it doesn''t work.
推荐答案
我不太了解您为什么需要使用两个列，但它仍然来自其中一列.但是，您始终可以使用未使用的定界符来连接两列，并将其用作单个查找.但是请确保它已正确排序.
I''m not really understanding why you need to use both columns, but it still comes from one. However, you can always use an unused delimiter to concatenate the two columns and use that as a single lookup. Make sure it is sorted correctly though.
这篇关于Excel Vlookup多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
