IFNA function

2016-06-04

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.

Syntax

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.

Example

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")

IFNA

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.

Subscribe

Advertisement

Related Articles

TRUE function

This function will return the TRUE value. This is the same as just entering...

read more

FALSE function

This function will return the FALSE value. This is the same as just entering...

read more

XOR function

This function will return TRUE if exactly one of the arguments are TRUE and...

read more

Comments

0 Comments

Get The Latest News

Follow Us

Follow us on social media to stay up to date with the latest tips in Excel!

Pin It on Pinterest

Share This