Row Variable assignment

[Guest]

I have several rows of data
where I need to divide column a by column c
I'd like to somewhere on the sheet enter in
a cell M4, say the munber 25
and have a formula in M5 to
be = a(cellM4)/c(CellM4)
Can this be done?

 

[Dave Peterson]

Maybe
=indirect("a"&m4)/indirect("C"&m4)
or
=index(a:a,m4)/index(c:c,m4)

 

[Guest]

Maybe......

=(A1*$M$4)/(C1*$M$4)

Vaya con Dios,
Chuck, CABGx3

 

[David Biddulph]

=(A1*$M$4)/(C1*$M$4) would be the same as =A1/C1, wouldn't it, Chuck?

I think the OP was looking at how to get A25/C25 in this case, so presumably
needs the INDIRECT function?