Cell Reference and Concatenate

[managingcrap]

For F5, the cell is already using concatenate but here's what I'
wanting to do. I want F5 to contain information from the 2nd row (i.e
35% and 11/13/2010). However, when i copy and paste the formula from F
to F5, F5 registers the values contained in C5 and D5 and not the value
on C2, and D2). Any help please.


Pls see the attached picture

+-------------------------------------------------------------------
|Filename: untitled.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=666
+-------------------------------------------------------------------

 

[Ron Rosenfeld]

For F5, the cell is already using concatenate but here's what I'm
wanting to do. I want F5 to contain information from the 2nd row (i.e.
35% and 11/13/2010). However, when i copy and paste the formula from F1
to F5, F5 registers the values contained in C5 and D5 and not the values
on C2, and D2). Any help please.


Pls see the attached picture.


+-------------------------------------------------------------------+
|Filename: untitled.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=666|
+-------------------------------------------------------------------+

Use absolute references in your formula: $C$2 instead of C2
Look at Absolute References in HELP