formula won't change correctly when dragged
 

In Excel 2003:
I have this formula: ='5West'!F33 and I want to drag it down to the cell
below this one and have the column reference ("F") change but not the row
reference ("33") so the new formula would be: ='5West'!G33. But instead it
changed the number and not the letter.
If I make the formula: ='5West'!F$33, then it drags the formula down as is
and still doesn't change the letter. How can I make it change the letter?
Thanks

formula won't change correctly when dragged
 

Assume you want the formulas entered starting in cell A1...

=INDEX('5West'!F$33:J$33,ROWS(A$1:A1))

Change J$33 to reflect the actual end of the range you're using.

--
Biff
Microsoft Excel MVP


"Meenie" wrote in message
...
In Excel 2003:
I have this formula: ='5West'!F33 and I want to drag it down to the cell
below this one and have the column reference ("F") change but not the row
reference ("33") so the new formula would be: ='5West'!G33. But instead it
changed the number and not the letter.
If I make the formula: ='5West'!F$33, then it drags the formula down as is
and still doesn't change the letter. How can I make it change the letter?
Thanks

formula won't change correctly when dragged
 

Wow, that works perfectly... now... is there a way to be able to drag it
across the rows so it does the same thing without changing the F...:J...?
(I know, I don't want much!)

"T. Valko" wrote:

Assume you want the formulas entered starting in cell A1...

=INDEX('5West'!F$33:J$33,ROWS(A$1:A1))

Change J$33 to reflect the actual end of the range you're using.

--
Biff
Microsoft Excel MVP


"Meenie" wrote in message
...
In Excel 2003:
I have this formula: ='5West'!F33 and I want to drag it down to the cell
below this one and have the column reference ("F") change but not the row
reference ("33") so the new formula would be: ='5West'!G33. But instead it
changed the number and not the letter.
If I make the formula: ='5West'!F$33, then it drags the formula down as is
and still doesn't change the letter. How can I make it change the letter?
Thanks

formula won't change correctly when dragged
 

OOO never mind I figured it out!!!!!!!! Thanks bunches!

"T. Valko" wrote:

Assume you want the formulas entered starting in cell A1...

=INDEX('5West'!F$33:J$33,ROWS(A$1:A1))

Change J$33 to reflect the actual end of the range you're using.

--
Biff
Microsoft Excel MVP


"Meenie" wrote in message
...
In Excel 2003:
I have this formula: ='5West'!F33 and I want to drag it down to the cell
below this one and have the column reference ("F") change but not the row
reference ("33") so the new formula would be: ='5West'!G33. But instead it
changed the number and not the letter.
If I make the formula: ='5West'!F$33, then it drags the formula down as is
and still doesn't change the letter. How can I make it change the letter?
Thanks

formula won't change correctly when dragged
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Meenie" wrote in message
...
OOO never mind I figured it out!!!!!!!! Thanks bunches!

"T. Valko" wrote:

Assume you want the formulas entered starting in cell A1...

=INDEX('5West'!F$33:J$33,ROWS(A$1:A1))

Change J$33 to reflect the actual end of the range you're using.

--
Biff
Microsoft Excel MVP


"Meenie" wrote in message
...
In Excel 2003:
I have this formula: ='5West'!F33 and I want to drag it down to the
cell
below this one and have the column reference ("F") change but not the
row
reference ("33") so the new formula would be: ='5West'!G33. But instead
it
changed the number and not the letter.
If I make the formula: ='5West'!F$33, then it drags the formula down as
is
and still doesn't change the letter. How can I make it change the
letter?
Thanks