# I see #N/A instead of content in some cells

Cause: One or more arguments is missing or omitted in the function.

 Solution: Enter all argumentsA value that a function uses to perform operations or calculations. The kind of argument that a function uses is specific to the function. Common arguments used within functions include numeric values, text values, cell references, ranges of cells, names, labels, and nested functions. in the function.

Cause: The formula uses a custom function that is not available.

 Solution: Make sure that the workbook that contains the custom function is open and that the custom function is working correctly.

Cause: An argument in an array formula does not reference the same number of rows or columns as the range that contains the array formula.

 Solution: Adjust the references in the array formula to match, or enter the array formula into fewer cells.

Cause: An inappropriate value is given for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP function.

 Solution: Make sure that the lookup_value argumentA value that a function uses to perform operations or calculations. The kind of argument that a function uses is specific to the function. Common arguments used within functions include numeric values, text values, cell references, ranges of cells, names, labels, and nested functions. is the correct type of value — for example, a value or a cell reference, but not a range reference.

Cause: The VLOOKUP, HLOOKUP, or MATCH function is used to locate a value in an unsorted table.

 Solution: Set the range_lookup argumentA value that a function uses to perform operations or calculations. The kind of argument that a function uses is specific to the function. Common arguments used within functions include numeric values, text values, cell references, ranges of cells, names, labels, and nested functions. to FALSE.

Cause: #N/A or =NA() has been entered in a referenced cell.

 Solution: Replace #N/A with new data.
 Rate this content: