Error signifies that something needs to be corrected in the syntax, so when you see the error in your formula, resolve it Do not use any errorhandling functions such as IFERROR to mask the error To avoid typos in formula names, use the Formula Wizard in ExcelError type Solution The solution is straightforward; In Vlookup formulas, the #N/A error message (meaning "not available") is displayed when Excel cannot find a lookup value There can be several reasons why that may happen 1 A typo or misprint in the lookup value
A Love In With Excel 39 S New Xlookup