when i copy a v-lookup formula in a col I am getting the value which it
returned in the 1st cell throughout the col.
Unless I am manually get into the cell and do enter, I am not able to see
the correct value returned by the formula for that cell.

Why does this happen? Can anybody help? Thanks in advance.