This week I want to show a quick method to avoid getting #N/A and 0 in the Vlookup results
#N/A and 0 usually show up in the result when the lookup value does not exist in the array list. Here is an example.
To avoid getting these unwanted values use the formula below instead of the Vlookup and just copy and paste your original VLOOKUP statement where the word HERE is located
The screenshot Below illustrates how the #N/As and 0s were replaced with blank spaces after I performed the foregoing.