UNDERSTAND & FIX EXCEL ERRORS: Download our free pdf
http://www.bluepecantraining.com/course/microsoft-excel-training/
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Visit http://www.bluepecantraining.com/portfolio/excels-null-error-and-the-intercept-operator/ for a written tutorial.

Excel's #NULL! error appears where you use the intersect operator (a space) where ranges don't actually intersect. You may accidentally use the intersect operator when you should have used a range operator such as a comma or colon. The video explains all.
------------------------