Greetings,

This issue occurs from time to time, and I have not pinpointed what causes it.

Typically, when I write a VLOOKUP formula and copy down, there is no issue. It automatically applies absolute reference to the range. What happens on the times it fails is that my formula does not automatically set absolute reference. I have to manually add the $-sign to the range in the formula, then copy down.

Thank you for support.