Formulas: referencing a value in another cell

  • What (I'm sure very simple) formula can I use to place the value of a particular cell, (let’s say D1) into a cell farther down that same column (let’s say D10) w/out using “=D1”? I would imagine the function “Column()” would come into play – but I’m not sure how.

  • What's wrong with “=D1”?

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

  • It's part of a bigger formula that I'll feed in via vba and I wanted to keep it as generic as possible. That is, if I can use "Column()" then I don't ever have to worry about correct assumptions on the part of the computer.

  • Quote

    Originally posted by tvsmvp
    It's part of a bigger formula that I'll feed in via vba and I wanted to keep it as generic as possible. That is, if I can use "Column()" then I don't ever have to worry about correct assumptions on the part of the computer.


    Don't get what you mean by 'correct assumptions on the part of the computer'


    ???

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

  • I'm going to place this formula into many cells across hundreds of columns - and I want the formula to automatically realize that I'm looking for the value of the first cell in that particular cell's column. If I say "=D1" it works for all cells in that column, but it doesn't realize which column otherwise. I need some generic reference to the "active" column, like "column()."

  • You could use something like =D$1 which when copied will always look at row 1 in column D. Your problem is more about the column and how the reference to it changes ie is the column relative or fixed or some other rule.


    HTH

    There are three types of people in this world.
    Those who can count and those who can't.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!