Menu
This is the scenario:
In cell A1 I have value "12".
In cell B1 I enter value "1".
In cell C1 I want to have value of Column "A" and row defined in cell B1.
How can I display the value "12"?
994
An absolute cell reference ensures that the formula is always refers to the same cell, even when it's copied and pasted. Absolute References remain constant no matter where they are copied. Add $ symbols to make the reference absolute. $E$1 is an example of an absolute cell reference.
=INDIRECT("A"&B1)
Help page for INDIRECT function: https://support.google.com/drive/answer/3093377?hl=en-GB
99
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
