Here's the situation: I have a list of numbers in a spreadsheet, all in a column. In another part of the spreadsheet, I'd like to refer back to the list, and get the value of a particular cell, based on a formula.
As an example: the list is from A1 down to A50. In another part of the spreadsheet, at C100 I would like to access a particular cell, based on the formula. Suppose it is A(5*5), which corresponds to A25. These formulas change depending on the cell I want to place the data.