S
S
Serg_Nvrsk2022-01-26 22:33:23
Google Sheets
Serg_Nvrsk, 2022-01-26 22:33:23

How to display an array of data in Google spreadsheets if the address of this array is specified in a cell?

Starting from cell A2, you need to display an array of data, the address of which is recorded in cell A1
For example, cell A1 contains the address of the array: AR$2:$AV
If you specify the formula ={A1} in cell A2, then simply the record AR$2:$AV is displayed
Tried enclosing the address in quotes does not help.
How to output an array?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
rPman, 2022-01-27
@Serg_Nvrsk

ADDRESS or INDEX was mistaken , Alexander
correctly said INDIRECT

S
Serg_Nvrsk, 2022-01-27
@Serg_Nvrsk

Thanks to! INDIRECT works!

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question