This error indicates that a value is not available to a function or formula.
Symptom
Excel displays #N/A in one or more cells on a worksheet.
Causes
- Data is missing, and #N/A or NA() has been entered in its place.
- An inappropriate value was given for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function.
- The VLOOKUP, HLOOKUP, or MATCH worksheet function was used to locate a value in an unsorted table.
- An array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) is using an argument that is not the same number of rows or columns as the range that contains the array formula.
- One or more required arguments were omitted from a built-in or custom worksheet function.
- A custom worksheet function that you use is not available.
- A macro that you run enters a function that returns #N/A
For more details on #N/A Errors do write me at Samrat.biswaas@gmail.com
No comments:
Post a Comment