If I were having your trouble, jolinchew, the first thing I'd check is whether the value is numeric in one workbook and a character string in the other. As I recall, VLOOKUP gets unhappy about that, and claims it couldn't find anything.