... Prev . Next . ... INDEX(array,[row, col, area]) . INDEX gives a reference to a cell in the given @array.The cell is pointed out by @row and @col, which count the rows and columnsin the array. If @row and @col are ommited the are assumed to be 1.@area has to be 1; references to multiple areas are not yet implemented.If the reference falls outside the range of the @array, INDEX returns a#REF! error. ... A5 contain numbers 11.4, 17.3,21.3, 25.9, and 40.1. ...