Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 0 down vote accepted

You can use this and sub the real formula you want for 5*5.

=INDIRECT(ADDRESS(5*5, 1))
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .