ExcelBanter - Vlookup Returning Zero For Every Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup Returning Zero For Every Cell (https://www.excelbanter.com/excel-worksheet-functions/447291-vlookup-returning-zero-every-cell.html)

Vlookup Returning Zero For Every Cell

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!

Quote:

Originally Posted by Clorber (Post 1606074)

Could you post an example worksheet with dummy data?