Hi,

I need to check a thing that I guess might result stupid for most of you here.
Couldn't find any online guide that has helped so far.

It's about using a cell to refer to an array, example A1:G1.

If I take for instance cell F5=A1:G1, then I get the value in the above mentioned array corresponding to column F. In other words, this formula just retrieves ONE CELL's value and it's not connected to the entire array anymore? Could you confirm this statement or please explain me how it really works? I have noticed that this works when the array is one dimensional, while the formula gives an error if you refer to more dimension or if you get outside the definition field of the array (like if I had taken cell L5, for instance.

Using an array formula will instead show only the first value of the array, F5={A1:G1}, so in this case A1. The cell contains though the entire array, am I right?

Thanks a lot in advance,

Cheers, Riccardo