C
Clorber
I am looking up and Employee ID to vlookup an amount specific to th
employee ID. When I do a simple (if(isna(vlookup(a2,'Previou
NPTO'!A:B,2,false)),"",(vlookup(a2,'Previous NPTO'!,A:B,2,false))) it i
pulling ALL zeros and not the correct number associated with th
employee ID. This is driving me crazy, and probably has the MOST simpl
solution.
I have already made sure they are all numbers and not text, and ther
are no merged cells, and there are no spaces in the columns precedin
the data.
PLEASE HELP
employee ID. When I do a simple (if(isna(vlookup(a2,'Previou
NPTO'!A:B,2,false)),"",(vlookup(a2,'Previous NPTO'!,A:B,2,false))) it i
pulling ALL zeros and not the correct number associated with th
employee ID. This is driving me crazy, and probably has the MOST simpl
solution.
I have already made sure they are all numbers and not text, and ther
are no merged cells, and there are no spaces in the columns precedin
the data.
PLEASE HELP