Constructing a Cell Reference

[AthleteTO]

Hi there,

I am trying to construct a formula using functions that require me to pass in a cell reference.

For instance, I have tried using variations of the following:

CELL("contents",CELL("col") & "3")

With the hope of producing the contents of K3.

Why not just refer to K3? It is part of a large formula, used throughout the worksheet, and does not propogate the relative reference. I want each formula to look at the contents of the 3rd row in that column.

Much appreciate any ideas!! This is something I've come across (and worked around) before, but this time, it's too huge to walk away without an answer. Why, oh why, can I not build a cell reference as a string?

Thanks in advance,
Drew

[olasa]

Is this what you are looking for?
=INDIRECT("K3") or =INDIRECT("R"&COLUMN()&"C3"),

Ola Sandström