View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Formula to reference another cell in a worksheet

=indirect("A" & G1)
--
HTH...

Jim Thomlinson


"HeatherJ" wrote:

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