Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

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

  1. #1
    Join Date
    12th July 2004
    Posts
    153

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

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

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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    16th June 2005
    Location
    Dublin
    Posts
    4,525

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

    Use

    VB:
    =indirect(B6) 
    
    
    for example.

    Ger

    NB.... Too slow
    _______________________________________________
    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

    _______________________________________________

  4. #4
    Join Date
    12th July 2004
    Posts
    153

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

    awesome! thanks a lot.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 3
    Last Post: February 6th, 2008, 22:47
  2. Clear A Cell's Contents
    By tm1274 in forum EXCEL HELP
    Replies: 6
    Last Post: March 7th, 2007, 02:44
  3. Getting the Current Cell's parameter
    By reloader in forum EXCEL HELP
    Replies: 1
    Last Post: October 26th, 2005, 20:43
  4. linking a cell's contents to a userform and back again
    By bigred0269 in forum EXCEL HELP
    Replies: 2
    Last Post: May 10th, 2005, 21:38
  5. insert row based on cell's value
    By MaxNDaisy in forum EXCEL HELP
    Replies: 5
    Last Post: February 8th, 2005, 22:28

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno