Hi,

Did u fix your table array with "$" ?

It'll be helpful if you provide more information.

"Sekhar" wrote:

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.