Thursday, February 27, 2014

MS Excel : IfError function in Excel 2010


Iferror is new function in MS Excel 2010 to make life simple. It works as:

IFERROR(value, value_if_error)

See it's use with vlookup below:

=Iferror(vlookup(A1,Sheet2!A1:C60, 3,False),”Not Found”)


In this formula, if vlookup returns error because value is not found, instead of returning  #N/A, it will return “Not Found”.