Formula to right

[deanl33069]

I have this formula in cell Ac2......=(aa2)
in cell ad2 in have .....=(aa3)
cell ae2...... =(aa4)
how can copy formula to into cells ? it changes the format of the formula so instead of ad2 come out as ab2
hope this make sense
basically i want to copy the formula to the right cell from column data

 

[Kenneth Hobson]

Use Absolute cell references or copy it from the formula box.

 

[Norie]

Try this in AC2 and copy across.

=INDEX($AA:$AA, COLUMNS($AC$2:AC2)+2)

 

[DanteAmor]

Another option:

=INDIRECT("AA" & COLUMNS($AC$1:AD1))