I have been trying to complete a vlookup using two different workbooks. I have follwed the instructions on this site and still am getting errors. I have received a "N/A" and "#NAME" I have version 2016 and I am very new at excel. Please help!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
troubleshoot vlookup
0
Discussion
We can't very well tell you what's wrong with your formula without your showing us what that formula looks like, or can we? The #NAME error points to a name being used that Excel didn't recognise - perhaps a range name or a range address that isn't a proper address. The #N/A error indicates that the look-up criterium wasn't found in the specified range. Since you are getting both these errors I guess that you are having a problem specifying the look-up range.
Variatus (rep: 4889) Apr 6, '20 at 8:24 pm
=vlookup(C2,[Book1]Sheet1!$A$1:$Q$369,17,0)
Unfortuantely this site does not allow me to copy/paste so I hope i copied it correctly?
Unfortuantely this site does not allow me to copy/paste so I hope i copied it correctly?
ninersfan23 Apr 6, '20 at 8:33 pm
[Book1] is a workbook which has never been saved. I expect that you may not be able to access it until it has been saved and has a proper name. And, this site does allow you to Copy/Base. But Excel doesn't allow you to copy a formula to the clipboard from a cell. You need to copy the formula from the Formula Bar and exit edit mode (press Enter) to complete the copy process.
Variatus (rep: 4889) Apr 7, '20 at 2:13 am
Answers
0
Hi Ninersfan,
sometimes while doing Vlookup, there is a small dropdown arrow which is green color on the cell and you need to format it correcly. For example if in the other file "4000" is format as a number and in another workbook "4000" is formatted as text, you will therefore get the NA.
I would request you to chekc the format.