Could it be that in your live data you have part numbers that are text and you're trying to match them against part numbers that are numeric? Even if the values look the same VLOOKUP doesn't treat them as the same.

You'd really have to show us an example of your problem.