When using VLOOKUP it is important to also reference the columns and not just the sheet name Using the worksheet name by itself in the "Table Array" portion of VLOOKUP will give you a #NAME? If you only want to fix the mistakes made by VLOOKUP not finding the lookup value, have IFNA used instead Doing this can ensure that the errors aside from #N/A don't get treated to have these other errors investigated Use the TRIM function if you want to treat trailing, leading, as well as double spacesErrors like this stand out, and it is quite awkward to have such errors in your excel templates To fix this, you could wrap your formulas in an IFERORR function and display a more meaningful message to the enduser
1
