+ Reply to Thread
Results 1 to 2 of 2

Cell linked to a "wandering" cell

  1. #1
    Registered User
    Join Date
    08-30-2007
    Posts
    11

    Cell linked to a "wandering" cell

    Here's the situation:

    I have a cell set to equal the value of a different cell

    i.e. Say, cell F1 is set to equal the value of cell E1. Except sometimes, I want F1 to return the value of E23, or E115, or whatever. So for one iteration, I may want to read E1 and on the second iteration I may want to read E23.

    The row number of the cell I want to read is defined in a different cell.

    i.e. If the value of A1 = 1, then I want F1 to read the value of E1. If A1 = 23, I want F1 to read the value of cell E23.

    I would like to know how to define cell F1. Is it possible to define F1 such that it reads column E and the row number equal to the value of A1?

    Being relatively new to Excel programming, I am not sure which functions I should use to accomplish this, if it is even possible. Does anyone have any suggestions?

    Thankfully,

    BK

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    tRY:

    =INDIRECT("E"&A1)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1