You can enter this in Col A
or any row in Col A
=INDIRECT("I"&(COLUMN()+27))
and drag across

If you start at Col D then use 24 instead of 27... so that column()+24 is 28
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"CM" wrote:

I've searched for an answer to this problem and learned about using the $ to
keep the row or column constant, but it does not seem to work the way I want
it to.

Problem: Formula is =I28
I want to drag this formula to the right (across columns) and have the
column ("I") stay constant, but the row number increment. Ideally, the
formulas from left to right would be =I28, =I29, =I30, etc...

=$I28 results in the same exact formula (=$I28) in every cell
=I$28 results in: =I$28, =J$28, =K$28, etc.

Is there some way to do what I want to do?
--

Thanks,
CM

Yes, it works. Thank you. But how strange! If I understand this correctly,
the column letter is converted into a number and added to the value after the
+ sign.
That is:
Starting in column A, then COLUMN() = 1
Starting in column B, then COLUMN() = 2

Is that correct?

Thanks again!
--
CM


"Sheeloo" wrote:

You can enter this in Col A
or any row in Col A
=INDIRECT("I"&(COLUMN()+27))
and drag across

If you start at Col D then use 24 instead of 27... so that column()+24 is 28
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"CM" wrote:

I've searched for an answer to this problem and learned about using the $ to
keep the row or column constant, but it does not seem to work the way I want
it to.

Problem: Formula is =I28
I want to drag this formula to the right (across columns) and have the
column ("I") stay constant, but the row number increment. Ideally, the
formulas from left to right would be =I28, =I29, =I30, etc...

=$I28 results in the same exact formula (=$I28) in every cell
=I$28 results in: =I$28, =J$28, =K$28, etc.

Is there some way to do what I want to do?
--

Thanks,
CM

the column letter is converted into a number and added to the value
Is that correct?

Yes.

Internally, Excel evaluates the columns as numbers. This is pretty easy to
follow up to column Z (column 26) since we all know there are 26 letters in
the (English) alphabet. After that it gets tricky! For example, if I need to
know the column number for column HK I'll scroll to column HK and enter this
formula in cell HK1: =COLUMN(). Excel will tell me that is column number
219.

--
Biff
Microsoft Excel MVP


"CM" wrote in message
...
Yes, it works. Thank you. But how strange! If I understand this
correctly,
the column letter is converted into a number and added to the value after
the
+ sign.
That is:
Starting in column A, then COLUMN() = 1
Starting in column B, then COLUMN() = 2

Is that correct?

Thanks again!
--
CM


"Sheeloo" wrote:

You can enter this in Col A
or any row in Col A
=INDIRECT("I"&(COLUMN()+27))
and drag across

If you start at Col D then use 24 instead of 27... so that column()+24 is
28
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"CM" wrote:

I've searched for an answer to this problem and learned about using the
$ to
keep the row or column constant, but it does not seem to work the way I
want
it to.

Problem: Formula is =I28
I want to drag this formula to the right (across columns) and have the
column ("I") stay constant, but the row number increment. Ideally,
the
formulas from left to right would be =I28, =I29, =I30, etc...

=$I28 results in the same exact formula (=$I28) in every cell
=I$28 results in: =I$28, =J$28, =K$28, etc.

Is there some way to do what I want to do?
--

Thanks,
CM