On Thu, 4 Oct 2012 20:38:01 +0000, Spencer101
wrote:


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

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.