Formula to reference another cell in a worksheet

[HeatherJ]

Column G is filled with numbers which represent Rows in my worksheet. I want
Column H to equal the contents of Column A Row ? which is referenced in
Column G.

Example:
G1 is 1043, I want H1 to be equal to A1043. What formula can I use to fill
column F to do this automatically.

Thank you!
Heather

 

[Jim Thomlinson]

=indirect("A" & G1)

 

[Gord Dibben]

=INDIRECT("A" & G1) entered in H1 and copied down

Don't know how column F fits in unless you meant F1 and not H1


Gord Dibben MS Excel MVP

 

[FloMM2]

HeatherJ,
If you want the cell in F column to equal the value in cell in the A column:
"=$A1" without the quotes (" ").
If you want the cell in the F column to equal the value in the cell A1:
"=$A$1" without the quotes (" ").
Depending on what you want (see above), copy and paste down the F column.
hth