i have another issue i just came across. the sheet its taking the data also
change i mean the first column looks in sheet name May second column looks in
sheet name June. when i copy paste it copies may all over the place. is
there a way to change it in the formula. its sounds painful to go in and
change the sheet name from may to june for 10000 lines. can someone please
help

"Stephen" wrote:

"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

No need for a macro. Go back to the original cell and change the reference
to absolute (A1 becomes $A$1, or whatever). Then copy/paste this as before,
and the reference will not change to B, C etc.