Vlookup Returning Zero For Every Cell

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
 
D

Don Guillett

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!

Send this msg and your file to dguillett1 @gmail.com
 
S

Spencer101

Clorber;1606074 said:
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!

Could you post an example worksheet with dummy data
 
C

CellShocked

Could you post an example worksheet with dummy data?


The cell type of the source data should be set to general.

If it was different, you may have to re-enter those values if it was
other than general.

The blank cell handling between 2k3 and 2k7 and up versions of office
is different as well. Make sure you are familiar with what elements you
do need and which you do not to insure your handling choices work.

You may also have added a column, shifting the lookup range number.

When you click on the little formula button next to the formula text
field, the formula dialog should pop up and show you just what each step
in the lookup resolves to. That should show you where the fail is
occurring at.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top