NA function. Generate N/A error.(Microsoft Excel)

Japanese version.

This function generates a #N/A error.

The #N/A error occurs when a search fails in the VLOOKUP or XLOOKUP function.

How it works


Example Results

Currently, this function has very limited use, such as when you want to generate an error as a result of an IF function.



Microsoft Excel Functions Information