Excel ISNA FunctionISNA function helps to get rid of #N/A code error Using ISNA function we can tell Excel to leave the cell blank or to display any desired text like “not found” instead of displaying #N/A code error. See how the function is used in the example: The function is
The above function has three parts: First part: =if(isna(vlookup(E4,list1,2,false)), It means if the function don’t find the value of cell E4 in List1 then display second part. Second part: “”, It means leave the cell blank. You can write text between quotation marks that you want to display instead of a blank cell. Third part: vlookup(E4,list1,2,false)) It means if the function finds the value then perform vlookup as usual. See the images given below:
|
- Maths Calculators
- All Calculators
- Calculators List
- Algebra Calculator
- Equation Solver
- Graphing Calculator
- Elimination Calculator – Solve System of Equations with
- Derivative Calculator
- Absolute Value Equation Calculator
- Adding Fractions Calculator
- Factoring Calculator
- Fraction Calculator
- Inequality Calculator
- Mixed Number Calculator
- Percentage Calculator
- Quadratic Equation Solver
- Quadratic Formula Calculator
- Scientific Notation Calculator
- Simplify Calculator
- System of Equations Calculator
- Class 12
- Class 11
- Class 10
- Class 9
- Class 8
- Class 7
- Class 6
- NCERT SOLUTIONS (1-5)
- NCERT MCQs
- Tally
- Accounting in Hindi
- Ms Office
- Python Tutorial
- Maths Calculators
- All Calculators
- Calculators List
- Algebra Calculator
- Equation Solver
- Graphing Calculator
- Elimination Calculator – Solve System of Equations with
- Derivative Calculator
- Absolute Value Equation Calculator
- Adding Fractions Calculator
- Factoring Calculator
- Fraction Calculator
- Inequality Calculator
- Mixed Number Calculator
- Percentage Calculator
- Quadratic Equation Solver
- Quadratic Formula Calculator
- Scientific Notation Calculator
- Simplify Calculator
- System of Equations Calculator
- Class 12
- Class 11
- Class 10
- Class 9
- Class 8
- Class 7
- Class 6
- NCERT SOLUTIONS (1-5)
- NCERT MCQs
- Tally
- Accounting in Hindi
- Ms Office
- Python Tutorial