| 1. | #N/A - Vlookup not found | |
| 2. | #NAME - cell reference doesn't exist | |
| 3. | #DIV/0 - formula is dividing by 0 use =if(a1=0,) | |
| 4. | #REF! - referring to a cell that's been moved or row that was deleted | |
| 5. | Step through formula calculation - Formulas > Formula Auditing > Evaluate Formula | |
| 6. | Circular Reference - in cell A1 and the formula =A1 | |
| 7. | External Link | |
| 8. | #VALUE! - the parameter to the function exceeded 255 characters or adding a string with a number | |
| 9. | Data not recalculating - Check options to see that Calculations set to Automatic |