Overcoming common problems - VLOOKUP

Unable to do a lookup? Entries look the same but lookup returns #N/A error. This is a formatting problem. To overcome this you have a couple of options. One is to copy the data from Excel and paste it to Notepad. This strips the data from any formatting. Copy the data from Notepad and paste it back to Excel. Presto ! Your lookup now works like a charm. An alternative method would be to do a TEXT to COLUMN under the DATA menu.