Using a cell to call another cell to start a range

asked 2019-06-19 17:48:05 +0100

Inouie gravatar image

Hello, i thought it would be easy to do as the title says, but i didn't find anything that worked so far so i'd really like your help.

I would like to use a cell outside of my calendar to call another one. so for exemple the AJ1 would call the A1 and this A1 should be the start of a range used in a function.

The problem is that i don't even know if what i'm trying to do is possible or not.

Thanks for your time and answers in advance!

(sorry if my english isn't correct)

edit retag flag offensive close merge delete


Cells do not "call" each other, so your requirement is quite unclear to me, but my gut feeling tells me, that you might want to take a look into INDIRECT - function

Opaque gravatar imageOpaque ( 2019-06-19 17:52:00 +0100 )edit

Thank you, I'll trust your guts then.

Edit: The thing is, for exemple =ADDRESS(3; 22; 4) return the value "V3" but i'd like to be able to use that value to start a range from V3 to AF3. Is this possible to use the value of a cell as a cell address in a formula? Or am i confusing myself too much?

Inouie gravatar imageInouie ( 2019-06-19 17:55:29 +0100 )edit

is this possible to use the value of a cell ... Yes, check INDIRECT. It is exactly for that purpose. Make a short example yourself, to see how it works:

Set cell A1 to "5" (without quotation mark)
Set cell B1 to contain "A1" (without quotation mark)
Set cell C1 to "=INDIRECT(B1)*10" (without quotation mark)

And C1 will evaluate to 50.

Opaque gravatar imageOpaque ( 2019-06-19 18:18:19 +0100 )edit