How To Remove N/A! Errors In Vlookup Formula
![employee list employee list](../wp-content/easy-excel/Vlookup/employee list.png)
![double click error double click error](../wp-content/easy-excel/Vlookup/double click error.png)
In this example formula is: =IF(ISNA(VLOOKUP(A6,A8:E17,2,FALSE)),””,VLOOKUP(A6,A8:E17,2,FALSE))
Note: Repeat step 1 & 2 on all the #N/A! errors.
Template
You can download the Template here – Download