See the image. It shows how multiple Vlookup functions have failed to find the values and throws #N/A errors.
The Vlookup's threw errors because the product mouse is not listed in the table data in Sheet2.
The error #N/A actually explains nothing except that there is an error. Using the IFERROR function, we can handle these errors and show an error message-using words that are easy understand (or simply leave the cell blank) and will pinpoint the cause of the error.
Trap #N/A errors in VLOOKUP formula using IFERROR and show Empty Text
Now, let's see how you can use IFERROR function to wrap your VLOOKUP formula and if there's an error, will show a blank text (or an empty text) in the cell.
First, see the syntax.
The other rows (for Sold and Date) will have the same formula (except the columns numbers).
Trap #N/A errors in VLOOKUP formula and Show your own Text
You can show a custom message of your own like a text message (a meaningful word or two) instead of a blank text or number values like zero etc., to describe the error. For example, if the product is not the list, instead of an error, show a message like Product not found or simply a 0. See the image.
Well, that's it. Thanks for reading. ☺