IFNA function

This function will return a specified value if your given expression results in an #N/A error. Only the #N/A! error will result in the alternate value.


IFNA(Expression, Value if #N/A!)

  • Expression (required) – This is part of the formula that is checked for an #N/A error.
  • Value if #N/A! (required) – This is the value that is returned if the expression results in an #N/A! error.


In this example we use the IFNA function with a VLOOKUP function. If the VLOOKUP function results in an #N/A! error (ie the lookup value was not found), then the IFNA function will return the text “Item not found”.

=IFNA(VLOOKUP(D2,$A$2:$B$6,2,FALSE),"Item not found")


About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.


Subscribe for awesome Microsoft Excel videos 😃

Related Posts



Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃