Excel-从不同的表单比较两个单元格，如果来自其他单元格的真值复制值 [英] Excel- compare two cell from different sheet, if true copy value from other cell

问题描述

所以，我有一个工作表A和工作表B。

So, I have a worksheet A and worksheet B.

我想比较两张表上的列A。

I would like to compare column A on both sheets with each other.

如果值与工作表B中的值相同（真），则从列F（此值为电子邮件地址，当然每行都不同）。

If the value is the same (true), than copy value from worksheet B, from column F (this value is email address, and it is of course different in every row).

我尝试使用VLOOKUP，但我无法弄清楚。我的excel知识很差。

I tried with VLOOKUP, but I cannot figure it out. My excel knowledge is quite poor.

请帮忙。感谢

编辑：
我想在第一张表中检查公司名称，以反映其他表格中的所有公司名称。而对于那些相同的人，复制电子邮件（我只在sheet2中）

I want to check company names in first sheet against all of the company names in the other sheet. And for those which are the same, copy the emails (which I have only in sheet2)

推荐答案

使用这样的VLOOKUP：

In your destination field you want to use VLOOKUP like so:

=VLOOKUP(Sheet1!A1:A100,Sheet2!A1:F100,6,FALSE)

VLOOKUP参数：

VLOOKUP Arguments:

1. 您要查找的设置字段。


2. 要查找您的值的表范围。您定义的表的第一列应该是您要与查找字段进行比较的列。表范围还应包含要显示的值（列F）。


3. 这将定义要在匹配时显示的字段。


4. FALSE告诉VLOOKUP进行完全匹配。

1. The set fields you want to lookup.
2. The table range you want to lookup up your value against. The first column of your defined table should be the column you want compared against your lookup field. The table range should also contain the value you want to display (Column F).
3. This defines what field you want to display upon a match.
4. FALSE tells VLOOKUP to do an exact match.

这篇关于Excel-从不同的表单比较两个单元格，如果来自其他单元格的真值复制值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！