Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reference to another worksheet cell in a sumproduct formula | Excel Discussion (Misc queries) | |||
formula to reference cell on previous worksheet | Excel Worksheet Functions | |||
need formula to reference a cell in previous worksheet | Excel Worksheet Functions | |||
Cell reference in different worksheet in formula | Excel Worksheet Functions | |||
What is the formula to reference a cell in a different worksheet? | Excel Worksheet Functions |