HOW TO COMBINING THE IFERROR FUNCTION FORMULA WITH VLOOKUP FUNCTIONS FORMULA IN EXCEL
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
Continue......
Page 2 >Page 3 >Page 4 >Page 5 >Page 6 >Page 7 >Page 8 >Page 9 >Page 10 >Page 11
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
Continue......
Page 2 >Page 3 >Page 4 >Page 5 >Page 6 >Page 7 >Page 8 >Page 9 >Page 10 >Page 11