How to reference to the fixed cell (when the entire column can be deleted)

[lukelucky]

Hi everybody,

I'd like to ask you about the help in one particular problem.

I'd need to reference to range of cell in the one column, that might be actually removed. I need to make the reference, that would remain static even if the column is removed (so far, it causes #REF error message).

Would you know any particular function to solve this issue?

Thank you very much for any suggestions!

[samba_ravi]

Use Indirect function like
=INDIRECT("A1")
change A1 as per your requirement

[lukelucky]

Thanks for the response! It really solve my first problem.

But now I have realized that I would need to keep some level of flexibility, so that one can also add or remove row above the reference cell.

Do you think that there is any way how to make INDIRECT function little more flexible?

Thank you!