Hi Excel community,

I am having an issue where my formula is not copying over to the other cells.
example:

I want the formula to say
=IF((C9=AA1),1,0) however im getting =IF((C10=AA3),1,0). I want the formula to always say AA1. when I use the formula + to copy down the formula the rows do not change to the formula I want. does any one know what the issue may be?

Thanks