How can I return a cell value using another cell value as the row reference

**tushare** · 05-07-2012, 11:30 AM

Hi there,

I have a list of numbers for example 1-10 in column A. I want to use those value in column c (for example) as a row reference. Something like = b(ro w(a1)), this would return the value of b1 using the values from A as a reference.

A B C
1 2 2
2 3 3
3 4 4
4 5 5
5 6 6
6 7 7
7 8 8
8 9 9
9 10 10

This is not exactly the type of thing that I want to do, it is just a simple example of what I would like to do. I can't seem to figure out how to use a value as part of the reference in another cell.

Thanks for any help,

TJ

**Cutter** · 05-07-2012, 11:47 AM

You can use, for that example:

=INDEX(B:B,A1)

**tushare** · 05-07-2012, 12:20 PM

that works, but I'm not sure how to apply that to my problem. basically I have data with column A being 1-121 and repeats 1-121 over and over. There are 121 time points basically in my data and each cycle of 121 represents an experiment. I would like to move all this data some that all the time points for 1-121 are in an array (e.g. time point for point 1 is from A1-G1, while point 2 is from A2-G2). I was hoping to return every 121st cell across columns and expand that each experiment is moved into a column. This could allow me to deal with my data the way I need to. I've added another example of what I want to do, there is a list of values in column A and I was to group them into different columns base on their reference location. Using the value in D1 which = 2 to return cell A2 then below it I would need A3 and so forth. Maybe there is a different way to do this??? Thanks for the help. I've also attached an example of my data and how it needs to be organized.

A b C D E F G H I J
1 L 2 4 6 8
2 M M O Q S
3 N N P R T
4 O
5 P
6 Q
7 R
8 S
9 T