Announcement

Collapse
No announcement yet.

Refer to another cell and grab that cell's referenced cell's contents

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Refer to another cell and grab that cell's referenced cell's contents



    Hi.

    I am trying to write the formula that would grap the content of cell 2 which is referenced in cell 1.

    how do i do that?

    file is attached.

    thanks.

    like i want a7 to display Rob, b7 to display Luis, etc..
    Attached Files

  • #2
    Re: Refer to another cell and grab that cell's referenced cell's contents

    Try this in A7 and copy across.
    Code:
    =INDIRECT("A"&A6)
    Boo!

    Comment


    • #3
      Re: Refer to another cell and grab that cell's referenced cell's contents

      Use

      Code:
      =indirect(B6)
      for example.

      Ger

      NB.... Too slow

      Check out our new reputation system. Click on the "star" under the post!
      _______________________________________________

      There are 10 types of people in the world. Those that understand Binary and those that dont.

      Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...

      The BEST Lookup function of all time

      Dynamic Named Ranges are your bestest friend

      _______________________________________________

      Comment


      • #4


        Re: Refer to another cell and grab that cell's referenced cell's contents

        awesome! thanks a lot.

        Comment

        Working...
        X