formula won't change correctly when dragged

M

Meenie

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
 
T

T. Valko

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.
 
M

Meenie

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!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using row number or column letters in formula 5
Simple calculation where values change to letters? 3
Locking a cell reference in a formula 1
Excel not correctly calculating formula 5
Using the result of formula as part of reference to a cell in form 8
Excel Use COUNTIF across a range of cells with formulas 0
automatically add to cell formula 7
how to create a variable column in cell reference 3

Top