| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Returning a copy of a cell | Excel Worksheet Functions | |||
| Returning the result of a vlookup in the same cell | Excel Worksheet Functions | |||
| VLookup returning #N/A when looking up a cell that has a Formula i | Excel Discussion (Misc queries) | |||
| VLookup Returning last cell?? | Excel Worksheet Functions | |||
| vlookup returning a value in more than one cell | Excel Worksheet Functions | |||
Threaded Mode
