CODEWITHSUNDEEP
excelexcel-formulaformulas
GPP
GPP

Reputation: 2335

VLOOKUP formula #Name errors

I am using Excel 2011 for Mac.

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

The current formula: =VLOOKUP(A1,NASM,3,FALSE)

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 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.

The values in Column A are all text strings.

How do I resolve this formula issue?

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

Upvotes: 0

Views: 4950

Answers (1)

rwilson
rwilson

Reputation: 2145

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.

Sheet With Formula

enter image description here

Sheet with Lookup Table (NASM)

enter image description here

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.

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

Upvotes: 2

Related Questions