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