Calling a cell value in an absolute cell reference

**tbonegrubb** · 04-14-2015, 12:59 PM

Hi,

I have a large set of data, in the rang of 1,000 to 3,000 data points, lets say they are all in volume B. I am selecting 25 of these point of witch I know the cell number. The cell number is stores in a different cell, lets say A1. And I want to display the value of the cell $B$1234, is the a way such that I could call it as $B$(the value of cell A1)?

Thanks

**alansidman** · 04-14-2015, 01:10 PM

What I am getting from your explanation is the use of the Indirect Function. Look at this link for a short explanation.

http://www.techonthenet.com/excel/formulas/indirect.php

**tbonegrubb** · 04-14-2015, 02:06 PM

Hi alansidman,

I played around with the INDIRECT function for a bit and its about have of what I need. Let me tray and explain this again. I have a data set of thousands of points, sorted by time. Each time point has a set of five values associated with it, speed, position and the like. I have a step of 25 top time points I need to their values (speed, position...ect) pulled out into a separate table. I have the row number of where each of the 25 values occur and am looking for a way to set a cell equal to a given column and row reference. Such as $AA$1234. However I have 12 sets of data and need multiple columns for each of the top 25 time points. So I am looking to a way to sub in the value of a cell( the row number) and a given column. So $AA$(row number stored in cell A3). Does that clarify what I am after? I had thought about use a macro, however I am on a mac and it doesn't support that function.

**MrShorty** · 04-14-2015, 02:31 PM

What I get from post 3 is something like the INDEX() function (list of lookup and reference functions: https://support.office.com/en-us/art...__toc309306714 ). Syntax is naturally different from cell references, but the idea is basically there.