Copying a specific cell by address based on a formula or function

**gfloras** · 12-16-2014, 06:16 PM

I would like to let us know, how to copy the value of a cell not like =a1 or b23 etc but the column (a...b...c) or the row (1...2..3..etc) could be a part of a algorythm.
Let's say if I have a row with values column A... and I want to copy in a column B the value of A(x) where x is the number of row but calculated
example

if I copy the B1 (which is =A1) to B2 it takes automatically the =a2...a3... a4 etc
A B C
1 12 =a1 -->12
2 13 =a2 -->13
3 14 =a3 -->14
4 15 =a4 -->15
5 18
6 20

But I want to find a function where I can give to the row a value taken let's say from the column C

A B C
1 12 =a1 -->12 1
2 13 =a3--->14 3
3 14 =a5--->18 5
4 15 =a7 --->29 7
5 18
6 20
7 29

Imagine a function like gus(text the letter of Column; number of row) which takes from everywhere the letter as a text and the number from anywhere as a value of functional result

Pease advice

**Pete_UK** · 12-16-2014, 09:59 PM

You can do this:

=INDIRECT("A" & C1)

and copy down. If the column letter(s) are in D1, then you can do this:

=INDIRECT($D$1 & C1)

Hope this helps.

Pete

**gfloras** · 12-17-2014, 01:29 AM

Thank you so much Pete from UK

I use also the function address() which returns the cells I want and then I put it into the indirect() and my "miracle" project ended successfully...

Thank you guys, have merry Xmas and I want to help your forum in the future regarding my level if I can...