Combining the IFERROR function Formula with Logical VLOOKUP Functions Formula
IFERROR Function With VLOOKUP Function Formula
Description : -
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR Function With VLOOKUP function to trap and handle errors in a formula
Below Following Values if Error : -
#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!
For Example
A B C D
Description Value Description Value Lookup
Product #N/A Product 0
Product Details #VALUE! Sale5 0
Item #REF! Sale 0
Sale #N/A Item 0
Sales #DIV/0! Name 0
Name #NAME? Num 0
Num #NUM! Null 0
Null #NULL! Product No. 125
Product No. 125 Product Data 220
Product Data 220 Product Details 0
IFERROR With VLOOKUP Formula
=IFERROR(VLOOKUP(D:D,A:B,2,FALSE),"0")
Here the Below Screenshot
Screenshot Image Link