This picture develops a clear understanding.

The two vectors (say A and B) of different magnitudes cannot be combined to give zero resultant since minimum value of combination is ІA-BІ which is not zero if AB.

The three vectors A, B and C of different magnitudes can be zero such that they form a closed triangle, then,

      A+B+C=0

or, C=-(A+B)

Hence, the sum of three vectors may be zero if vector sum of any two vectors is equal and opposite to the third vector.

Note: The vectors can give this result only if...

Yes, a vector which has zero magnitude is also a vector in case of two vectors travelling in opposite directions with equal magnitudes. At this case, the resultant vector has zero magnitude but it is still a vector. We call it a null vector.