In this HR Resources Post, we’ve created a YouTube tutorial which supplements the vLookUp tutorial we did earlier. The single largest complaint I hear about vLookUps is the N/A ‘error’ which is returned when no data is present to be matched through the vLookup formula. The IFERROR is a formatting formula, designed to return a blank (or a desired term determined by the excel user). So if this is an issue you encounter when showing your spreadsheets to colleagues and/or end-users, take a look I’m sure you’ll find this formula helpful.