The formula will return an error if your vlookup is running off of a search that was unsuccessful. It's not clear what you're desired outcome is. If you want to remove the error and replace it with something else, simply add =IFERROR(your full equation,then whatever you want it to return if there is no match). For example, =IFERROR(formula,"") will return blanks when there is an error.