Excel中的Excel vlookup与CSV

问题描述

您好，我有一份ReportOwnerQuery工作表，其中包含C列中的电子邮件列表，例如 [email protected]，[email protected] 等逗号分隔。我需要Vlookup或类似的方法来检查ReportOwnerQuery的C列中的一封电子邮件是否在OwnerList表上，其中包含 A2：A60 中的所有者电子邮件。如果其中一封电子邮件是该单元格的所有者电子邮件，则将其放入ReportOwnerQuery的D列中。如果有这样的VBA也可以帮助我也很乐意使用它。



我尝试了什么：



在ReportOwnerQuery的单元格D2中： = VLOOKUP（&*，OwnerList！A1：A1000,1，FALSE）返回#N / A

在ReportOwnerQuery的单元格D2中： = VLOOKUP（&*，OwnerList！A1：A1000,1，TRUE）从OwnerList返回不正确的电子邮件

Hello, I have a ReportOwnerQuery Sheet with a list of emails in with Column C being seperated by commas like "[email protected], [email protected]". I need to Vlookup or a similar method to check to see if one of the emails in column C of ReportOwnerQuery is on the OwnerList sheet which contains owner emails in A2:A60. If one of those emails is an owner email for the cell then place in in Column D of ReportOwnerQuery. If there is a VBA for this as well that could help I would gladly use that too.

What I have tried:

In cell D2 of ReportOwnerQuery: =VLOOKUP(&"*",OwnerList!A1:A1000,1,FALSE) returns a #N/A
In cell D2 of ReportOwnerQuery: =VLOOKUP(&"*",OwnerList!A1:A1000,1,TRUE) returns an incorrect email from OwnerList

推荐答案

引用：

在ReportOwnerQuery的单元格D2中：= VLOOKUP（&*，OwnerList！A1：A1000,1，FALSE）返回#N / A

In ReportOwnerQuery的单元格D2：= VLOOKUP（& *，OwnerList！A1：A1000,1，TRUE）从OwnerList返回不正确的电子邮件

In cell D2 of ReportOwnerQuery: =VLOOKUP(&"*",OwnerList!A1:A1000,1,FALSE) returns a #N/A
In cell D2 of ReportOwnerQuery: =VLOOKUP(&"*",OwnerList!A1:A1000,1,TRUE) returns an incorrect email from OwnerList

这正是VLOOKUP的预期行为。

This is exactly the expected behavior for VLOOKUP.

Quote：

如果其中一封电子邮件是该单元格的所有者电子邮件，则将其放入ReportOwnerQuery的D列。

If one of those emails is an owner email for the cell then place in in Column D of ReportOwnerQuery.

是但是当没有匹配时要放在单元格中的内容？

因为你所描述的行为是电子邮件地址不在列表中的行为。

我会尝试类似的东西：

Yes but what to put in cell when there is no match ?
Because the behavior you describe is the one when the email address is not in the list.
I would try something like:

=IF(ISERROR(VLOOKUP(&"*",OwnerList!A1:A1000,1,FALSE)),your result,your result)
or
=IFERROR(VLOOKUP(&"*",OwnerList!A1:A1000,1,FALSE),your result)

这篇关于Excel中的Excel vlookup与CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！