Excel VLOOKUP #N/A

Environment

• Microsoft Office Excel 2003/2007

Problem
Although all column are using General Category, VLOOKUP still got #N/A result

Solution
Make a new column via

A1 * 10 / 10

Then replace the problem column