EXCEL:需要从另一个工作表中找到一个单元格区域中的值，并从相邻的单元格中返回值 [英] EXCEL: Need to find a value in a range of cells from another worksheet and return value from adjacent cell

问题描述

我正在尝试查找在工作表"ABC"的A列中搜索的公式，以找到与工作表"XYZ"中的G4匹配的值.找到该值后，返回相邻单元格的值(列B工作表"XYZ"中存在此公式的单元格的"ABC").所有工作表都在同一工作簿中.

I am trying to find the formula that will search in column A (of worksheet "ABC") to find a value matching G4 in worksheet "XYZ" Once that value is found, return the value of the cell adjacent (column B of "ABC") to the cell in which this formula exists in worksheet "XYZ". All sheets are in the same workbook.

非常感谢您！

推荐答案

以下是您所描述的示例:

here's an example of what you're describing:

在电子表格ABC中，您在A列中有一个参考值，在B列中有数据

In spreadsheet ABC, you have a reference value in column A and data in column B

在电子表格XYZ中，您在A列中有一个匹配的数字.您要将电子表格ABC中的数据与XYZ中的值配对:

In spreadsheet XYZ, you have a matching number in column A. You'd like to pair the data from spreadsheet ABC to the value in XYZ:

如果您注意到第二张图片的公式栏中的公式，您将看到vlookup公式来提取此示例的数据.我还在单元格B1中的公式前面添加了撇号(图2)，以使其显示公式.请注意，这些公式指向的参考单元格有所不同.

If you notice the formula in the formula bar on the second picture, you'll see the vlookup formula to pull the data for this example. I also added an apostrophe in front of the formula in cell B1 (image 2) to have it display the formula. Note the formulas are slightly different since they point to different reference cells.

此外，这是有关vlookup函数如何工作的很好的参考:

Also, here's a great reference for how the vlookup function works:

http://chandoo.org/wp/2012/03/30/comprehensive-guide-excel-vlookup/

这篇关于EXCEL:需要从另一个工作表中找到一个单元格区域中的值，并从相邻的单元格中返回值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！