copy formula without changing all the cell references

[cornepiek]

hi all

can someone please help me.
how do one structure a formula to so that when being copied only certain parts are updated.

heres an example:
i have a cell that i need to display a certain value, depends on the cell value of another cell.
the cell value i need to display will be the contents of a specific set of cells.

here is the formula: (formula in C2)
=IF(AA2=0,"",IF(AA2=1,I2,IF(AA2=2,I3)))

rather simple.
cell AA2 needs to update as the formula is copied. this column is auto populated with a data import. the values will always be 0, 1 or 2

cells I2 and I3 contains the data reference i need. these MUST stay the same in the formula.

so when i then copy the formula, i need it to automatically update in the following manner:

C2: =IF(AA2=0,"",IF(AA2=1,I2,IF(AA2=2,I3)))
C3: =IF(AA3=0,"",IF(AA3=1,I2,IF(AA3=2,I3)))
C4: =IF(AA4=0,"",IF(AA4=1,I2,IF(AA4=2,I3)))

can someone please assist. i know there is a simple way of accomplishing this


thanks

 

[Aladin Akyurek]

C2, copy down:

=IF(AA2=0,"",IF(AA2=1,$I$2,IF(AA2=2,$I$3)))

 

[cornepiek]

thanks a million

 

[Aladin Akyurek]

thanks a million

You are welcome. Thanks for providing feedback.