Hello to all,
Some data are saved, in a single cell with the following format:
{"test1";"test2";"test3"}, Let's say this array is in cell A1.
But at the same I want to use the Index function, in another cell, to get the value of my preference, from the array above.
Example: =Index(Range;2)
Is there a way to make this function to understand the A1 cell as a range? (Range=A1)
I am aware, that I can use the following syntax: =Index({"test1";"test2";"test3"};2).
I have tried with Indirect. But couldn't find a way.
I hope there is a method.
Thanks.
Some data are saved, in a single cell with the following format:
{"test1";"test2";"test3"}, Let's say this array is in cell A1.
But at the same I want to use the Index function, in another cell, to get the value of my preference, from the array above.
Example: =Index(Range;2)
Is there a way to make this function to understand the A1 cell as a range? (Range=A1)
I am aware, that I can use the following syntax: =Index({"test1";"test2";"test3"};2).
I have tried with Indirect. But couldn't find a way.
I hope there is a method.
Thanks.