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