Cell references within formulae

[Jodyeph]

I want to reference a particular cell (call it N1018) from within an array
contained in a formula so that the starting row for the array is determined
by the number located within the cell N1018, e.g., the formula might read as
follows: =median(p(n1018)37) where the value of N1018 is the row number
of cell p(N1018) That is, I want the formula to read =MEDIAN(p1537) if the
value in N1018 is 15. If the value of N1018 was 6, then the formula would be
=MEDIAN(p637), etc.

 

[Mike H]

Try

=MEDIAN(INDIRECT("P" & N1018 &"37"))

Mike