Buzz
This article introduces the NA function – one of the widely used information functions in Excel.
Description: The function returns the #N/A error value, indicating no matching value found.
Syntax: NA()
- The NA() function does not have any parameters.
Note:
- Include empty parentheses in the function name.
- You can directly enter the value #N/A into the cell to mark it as empty.
Example:
Determine the return value of the MATCH, VLOOKUP functions described in the data table below:
- Search for the string 'abc' in the data table. In the cell for calculation, enter the formula =VLOOKUP('abc',B5:C9,2)
- Press Enter -> the return value is:
- The string 'abc' is not found in the data table -> the function returns the error value #N/A.
- Similarly with the MATCH function -> enter the formula: =MATCH('1234',B5:C10,0)
- Press Enter -> the return value is:
- Similarly, copy the formula for the remaining values to get the result:
Here is a guide and specific examples of using the NA function in Excel.
Wishing you all success!
