Google Product Forums

How to keep cell number in formula inserting a new row ?

jrccc Jun 27, 2012 1:45 AM
Posted in group: Google Docs Help Forum

Categories: Desktop - Other (please specify) : Ask a "how-to" question : Sheets :


Here is my issue.

I have my spreadsheet

I have a formula (in another tab) which compares a value "X" with the content of A2.
When I insert a new row between A1 and A2, A2 becomes A3, and then my formula compares the value with the content of A3. But I still want to compare my value with the content of A2.

Is there a way to keep always the same cell number in my formula, in despite of insertions ?
I took a look to ArrayFormula, but I don't see how it could work with that feature.

Does someone know how to solve this issue ?

Thanks a lot,