MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How retrieve value from array that entered in cell directly (={...} )?


Posted by Sergei on November 11, 2000 6:33 PM

I tryed INDEX() function, but I had error message #REF

Track of problem:
1) Input in cell A1 ={1,2,3}
2) Try retrieve value "2" or "3"

How retrieve value from array that entered in cell directly (={...} )?


Posted by Ivan Moala on November 11, 2000 8:09 PM

The input of ={1,2,3,4} is not treated as an array
You can however Define an array as ={1,2,3,4 etc)
and call this MyArray......then use Index to refer
the number you want eg. =Index(MyArray,4) would
give you 4.


Ivan