使用过滤器相匹配,并防止不正确的数据,由于空白细胞

0

的问题

我试着匹配数据从两个不同的床单和带来一个列表中的公司名称从该行匹配

A1:A1000 = List of Companies
E1:E5000 = List of Matchable IDs
C1 = Manually Input ID

下面的宏工作:

=IFERROR(FILTER('List Companies'!A1:A1000,'List Companies'!E1:E1000='ID Sheet'!C1),"")

然而,如果C9是空白的返回不正确的名单。

如果我尝试和使用如下:

=IF(ISBLANK('ID Sheet'!C1), "", IFERROR(FILTER('List Companies'!A1:A1000,'List Companies'!E1:E1000='ID Sheet'!C1),""))

它返回:

"~ERROR"

我确定我一定是做错了什么但我不知道我在做什么错了...如果任何人都可以指出我的错误我将非常感谢一些帮助。

1

最好的答案

1

VLOOKUP 它。

如果C1是人工输入的身份证然后:

=IFNA(VLOOKUP('ID Sheet'!C1, {'List Companies'!E:E, 'List Companies'!A:A}, 2, 0))
2021-11-24 10:16:42

其他语言

此页面有其他语言版本

Русский
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................