NA function - The function returns the # N / A error value in Excel

The following article introduces you to the function NA - 1 of the functions in the information function group is very popular in Excel.

NA function - The function returns the # N / A error value in Excel Picture 1

Description: The function returns the N / A error value, which means that no values ​​match the search results.

Syntax: NA ()

- The NA () function contains no arguments.

Attention:

- Must enclose parentheses in the function name.

- You can enter the value # N / A immediately in the cell to mark the blank value.

For example:

Determining the return value of the MATCH and VLOOKUP functions is described in the following data table:

NA function - The function returns the # N / A error value in Excel Picture 2

- Find the value of the string 'abc' in the data table. In a cell to calculate, enter the formula : = VLOOKUP ("abc", B5: C9,2)

NA function - The function returns the # N / A error value in Excel Picture 3

- Press Enter -> return value is:

NA function - The function returns the # N / A error value in Excel Picture 4

- The string 'abc' is not in the data table -> the function returns the # N / A error value .

- Similar to the MATCH function -> enter the formula: = MATCH ("1234", B5: C10,0)

NA function - The function returns the # N / A error value in Excel Picture 5

- Press Enter -> return value is:

NA function - The function returns the # N / A error value in Excel Picture 6

- Similarly copying the formula for the remaining values ​​results:

NA function - The function returns the # N / A error value in Excel Picture 7

Above are instructions and some specific examples when using the NA function in Excel.

Good luck!