The #NULL error occurs when you use an incorrect range operator in a formula or when you use an intersection operator (space character)  between range references. The #NULL error specifies that the two ranges do not intersect.