Tutorial: Don’t show #N/A if the VLOOKUP value isn’t found

By | April 30, 2015

The Problem

You might be expecting that not all of your search values are going to return something from the search table. Instead of the formula returning #N/A you’d like the result to look different when your VLOOKUP value isn’t found (either blank or an indicator to show that the value hasn’t been found or a zero if you’re wanting to do maths with the results).

The Solution

You can use the iferror function.

It works like this.

= iferror (YourVlookupFormula, WhatToSayInsteadOf#N/A)

Here’s an example.

=iferror(VLOOKUP(D3,A:C,3,false), “No Value Found”)

Or if you would rather it was just blank then instead of having No Value Found, just have the two sets of inverted commas, like this.

=iferror(VLOOKUP(D3,A:C,3,false), “”)

 

Want to get good at using the VLOOKUP function?

Download our practical VLOOKUP tutorial workbook with step-by-step instructions and examples to help you become a VLOOKUP pro.

One thought on “Tutorial: Don’t show #N/A if the VLOOKUP value isn’t found

Leave a Reply

Your email address will not be published. Required fields are marked *