VLOOKUP与MATCH一起 [英] VLOOKUP together with MATCH
问题描述
我有以下查找条件,但似乎无法使其正常工作。
= VLOOKUP(A1,'Raw数据'!A1:A3,MATCH('提交数据'!B1,'提交数据'!A1:B1))
我试图从提交的数据
中的B列值中引入原始数据
根据A列上的匹配,我只是不断收到错误。
原始数据
ABC
pre>
1 L1 23
2 L2 17
3 L7 31
已提交数据
AB
1 L1完成
2 L7待定
3 L2完成
解决方案
vlookup
为您提供匹配
,以便您不需要该功能。这应该适用于你:= VLOOKUP(A1,'Submitted Data'!A1:B3,2,FALSE)
其中
A1
是您要在不同单元格范围内找到的值的单元格(即另一张表中的数据。
提交数据!!A1:B3
是包含要查找A1
的数据的单元格范围,然后返回该值是一个定义的列数(远离它)(见下一句)。
2
是列从提交的数据'!A1:B3
(即列B
),具有您要返回的值。
FALSE
表示您希望与您的A1
值。I have the below lookup condition but can't seem to get it working.
=VLOOKUP(A1,'Raw Data'!A1:A3,MATCH('Submitted Data'!B1,'Submitted Data'!A1:B1))
I'm trying to pull in the B column value from
Submitted Data
into the B column inRaw Data
based of a match on A columns, I just keep getting an error.Raw Data
A B C 1 L1 23 2 L2 17 3 L7 31
Submitted Data
A B 1 L1 Complete 2 L7 Pending 3 L2 Complete
解决方案
vlookup
does thematch
for you so you don't need that function. This should work for you:=VLOOKUP(A1, 'Submitted Data'!A1:B3,2,FALSE)
Where
A1
is the cell with the value you want to find in a different range of cells (i.e, the data on the other sheet.
Submitted Data'!A1:B3
is the range of cells containing the data you want to find yourA1
in, and then return the value that's a defined number of columns away from it (see the next sentence).
2
is the column from the rangeSubmitted Data'!A1:B3
(i.e. columnB
) that has the value you want to return.
FALSE
means you want an exact match for yourA1
value.这篇关于VLOOKUP与MATCH一起的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!