Originally Posted by Clorber

I am looking up and Employee ID to vlookup an amount specific to the employee ID. When I do a simple (if(isna(vlookup(a2,'Previous NPTO'!A:B,2,false)),"",(vlookup(a2,'Previous NPTO'!,A:B,2,false))) it is pulling ALL zeros and not the correct number associated with the employee ID. This is driving me crazy, and probably has the MOST simple solution.

I have already made sure they are all numbers and not text, and there are no merged cells, and there are no spaces in the columns preceding the data.

PLEASE HELP!