Solution: Either make sure that the lookup value exists in the source data, or use an error handler such as IFERROR in the formula. For example, =IFERROR (FORMULA (),0), which says: You can use “” to display nothing, or substitute your own text: =IFERROR (FORMULA (),”Error Message here”) More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.