I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

hi,

Try this in a12 and drag right

=INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) )

Mike

"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

In A12
=A10*J1

Copy the cell. Select the required cells from A13 to An. Right clickPaste
SpecialFormulas..OK

If this post helps click Yes
---------------
Jacob Skaria


"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

It's close...however, the J is changing to a K...it needs to copy down to J2,
J3, etc...

"Mike H" wrote:

hi,

Try this in a12 and drag right

=INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) )

Mike

"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

Oops, Jean please ignore the below post. I misread..
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

In A12
=A10*J1

Copy the cell. Select the required cells from A13 to An. Right clickPaste
SpecialFormulas..OK

If this post helps click Yes
---------------
Jacob Skaria


"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

I think I'm all set, Mike...I ust needed to make the J and absolute. Thanks
so much!!!!

"Mike H" wrote:

hi,

Try this in a12 and drag right

=INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) )

Mike

"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

So sorry...it's still not working. If I Absolute the J, it does remain in
column J. However, the formula is not dropping down to the next row in
column J.

"Mike H" wrote:

hi,

Try this in a12 and drag right

=INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) )

Mike

"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

The highlighted references does not matter. If you are looking at

A10*J1
A11*J2
A12*J3
the formula should work

=INDIRECT("A"&COLUMN(J1))*INDIRECT("J"&COLUMN(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Jean" wrote:

So sorry...it's still not working. If I Absolute the J, it does remain in
column J. However, the formula is not dropping down to the next row in
column J.

"Mike H" wrote:

hi,

Try this in a12 and drag right

=INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) )

Mike

"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

What I would like the formula to do is:

A10*J1
B10*J2
C10*J3

"Jacob Skaria" wrote:

The highlighted references does not matter. If you are looking at

A10*J1
A11*J2
A12*J3
the formula should work

=INDIRECT("A"&COLUMN(J1))*INDIRECT("J"&COLUMN(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Jean" wrote:

So sorry...it's still not working. If I Absolute the J, it does remain in
column J. However, the formula is not dropping down to the next row in
column J.

"Mike H" wrote:

hi,

Try this in a12 and drag right

=INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) )

Mike

"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

Try

=INDEX(10:10,1,COLUMN(A1))*INDIRECT("J"&COLUMN(A1) )

If this post helps click Yes
---------------
Jacob Skaria


"Jean" wrote:

What I would like the formula to do is:

A10*J1
B10*J2
C10*J3

"Jacob Skaria" wrote:

The highlighted references does not matter. If you are looking at

A10*J1
A11*J2
A12*J3
the formula should work

=INDIRECT("A"&COLUMN(J1))*INDIRECT("J"&COLUMN(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Jean" wrote:

So sorry...it's still not working. If I Absolute the J, it does remain in
column J. However, the formula is not dropping down to the next row in
column J.

"Mike H" wrote:

hi,

Try this in a12 and drag right

=INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) )

Mike

"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.

YES!!!!!! Thanks so much!

"Jacob Skaria" wrote:

Try

=INDEX(10:10,1,COLUMN(A1))*INDIRECT("J"&COLUMN(A1) )

If this post helps click Yes
---------------
Jacob Skaria


"Jean" wrote:

What I would like the formula to do is:

A10*J1
B10*J2
C10*J3

"Jacob Skaria" wrote:

The highlighted references does not matter. If you are looking at

A10*J1
A11*J2
A12*J3
the formula should work

=INDIRECT("A"&COLUMN(J1))*INDIRECT("J"&COLUMN(A1))

If this post helps click Yes
---------------
Jacob Skaria


"Jean" wrote:

So sorry...it's still not working. If I Absolute the J, it does remain in
column J. However, the formula is not dropping down to the next row in
column J.

"Mike H" wrote:

hi,

Try this in a12 and drag right

=INDIRECT("A"&COLUMN(J10))*INDIRECT("J"&COLUMN(A1) )

Mike

"Jean" wrote:

I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.