Microsoft Excel – Vlookup works only when i double click the looked up cell. The easiest way to get the values recognized as Text is to select the range (this can be the entire column) and use Data|Text to Columns from the menu. Just click Next on the first two dialog boxes and then choose Text as the Column data format on the third and then Finish.Vlookup is a very useful function within Excel, but occasionally it will stubbornly return "#N/A" results when you can clearly see that the value you are looking up exists in the reference table.excel vlookup not working – solutions for N/A, NAME and VALUE errors by Svetlana Cheusheva | updated on March 26, 2018 129 Comments The tutorial explains how you can quickly cope with VLOOKUP not working problems in Excel 2016, 2013, 2010, 2007 and 2003, troubleshoot and fix common errors and overcome VLOOKUP’s limitations.23 things you should know about VLOOKUP When you want to pull information from a table, the Excel VLOOKUP function is a great solution. The ability to dynamically lookup and retrieve information from a table is a game-changer for many users, and you’ll find VLOOKUP everywhere.

This video,, can also be seen at of your VLOOKUPs are working, so you click on the lookup reference of your data set. In the formula bar you see an apostrophe before your intended number entry. solution: Multiply all of your lookup values by 1. This usually occurs when someone is trying to show a leading zero in front a number.Go to the "Font" group of the "Home" tab on the ribbon and click the little arrow next to the "Borders" button. Right click and select "Format Cells". Then go to the "Border" tab. Select a thick border from the "Style" options and click on the "Outline" preset.The VLOOKUP function in Excel finds things in a table or range by row. The secret is to organize your data so that the value you look up is to the left of the value you want to find. Then use VLOOKUP to find the value.