You could go back to the original formula, make the A an absolute reference
(put a $ in front of it) and copy it down again.


"Arain" wrote in message
...
I wrote a vlookup formula to look for a value in cell reference of sheet
two.
i copy pasted the formul horizontally. later when it was giving n/a i
realized when i copy pasted the vlookup it changed the cell reference from
A
to B and the C. Is there a way to fix it without going through each cell
and
changing it back to A.

Thanks