absolute & relative references
Perfect! Thank You!
"zzulu4" wrote:
I am trying to copy an if function. =IF($C$4='April 09'!$B38,"HIT","HOLD").
I want column B to be ablsolute and the row to be relative. However, I am
trying copy and display the results across columns (instead of rows) on a
different sheet. When I copy the formula down it works perfectly....when I
try to go across, it gets compared to Cell B38. Make sense? Any suggestions?
|