Excel - 基于另一个列表提取数据 [英] Excel - extracting data based on another list
问题描述
我尝试使用过滤器,但无法使其工作。
谢谢。
新的Excel版本
= IF(ISNA(VLOOKUP(A1,B,B,1,FALSE)),,A1)
/ p>
旧的Excel版本
= IF(ISNA(VLOOKUP(A1; B:B ; 1; FALSE));; A1)
即:如果A1的值存在于B列中,在这里,如果不存在,请将其留空。
I have an Excel worksheet with two columns (name/ID) and then another list that is a subset of the names only from the larger aforementioned list. I want to go through the subset list and then pull the data from the larger list (name/ID) and put it somewhere else...essentially only grabbing the data from the larger list if the name is on the subset.
I tried using Filters, but couldn't get it work. Thoughts?
Thanks.
New Excel versions
=IF(ISNA(VLOOKUP(A1,B,B,1,FALSE)),"",A1)
Older Excel versions
=IF(ISNA(VLOOKUP(A1;B:B;1;FALSE));"";A1)
That is: "If the value of A1 exists in the B column, display it here. If it doesn't exist, leave it empty."
这篇关于Excel - 基于另一个列表提取数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!