VLOOKUP公式#Name错误 [英] VLOOKUP formula #Name errors

问题描述

我正在使用Excel 2011 for Mac.

I am using Excel 2011 for Mac.

我只得到#NAME吗?当我尝试在同一工作簿的另一个工作表中查找重复项时出现错误.

I am only getting #NAME? errors when I try to lookup for duplicates in another worksheet in the same workbook.

当前公式: =VLOOKUP(A1,NASM,3,FALSE)

当我尝试将NASM(我要查找的工作表)换成单个标记('')时，excel公式错误对话框阻止我计算公式

when I tried wrapping NASM (the worksheet I am trying to lookup) in single marks ('') an excel Formula Error dialog prevents me from calculating the formula

2005 Excel显然允许用户在计算部分中选中接受公式中的标签复选框"框，但该选项在此版本中不可用.

2005 Excel apparently let users check a box in the calculation section that 'Accept labels in formulas check box' but that option is not available in this version.

A列中的值都是文本字符串.

The values in Column A are all text strings.

如何解决此公式问题?

How do I resolve this formula issue?

我要提到的是，该工作簿有两个工作表，并且NASM工作表是通过移动或复制"按钮导入到该工作簿中的.

edit: I should mention that this workbook has two worksheets, and the NASM worksheet was imported into this workbook via the "Move or Copy" button

推荐答案

使用VLOOKUP时，不仅要引用表名，而且还要引用列，这一点很重要.在VLOOKUP的表数组"部分中单独使用工作表名称将为您提供#NAME?错误.

When using VLOOKUP it is important to also reference the columns and not just the sheet name. Using the worksheet name by itself in the "Table Array" portion of VLOOKUP will give you a #NAME? error.

此处A2在NASM表的A列中搜索匹配项.找到匹配项后，它将返回在C列中找到的值.

Here A2 searches for a match in column A on the NASM sheet. Once the match is found it then returns the value found in column C.

在下面的链接中查看Mike Girvin(最好的Excel讲师IMO)的VLOOKUP公式基础视频.

Check-Out Mike Girvin's (The BEST Excel instructor IMO) video on the basics of the VLOOKUP formula in the link below.

https://www.youtube.com/watch?v=GZX2iXfqALs

这篇关于VLOOKUP公式#Name错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！