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

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

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

2. ## Re: How can I return a cell value using another cell value as the row reference

You can use, for that example:

=INDEX(B:B,A1)

3. ## Re: How can I return a cell value using another cell value as the row reference

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1