+ Reply to Thread
Results 1 to 4 of 4

Referencing a cell based on the value in another cell

  1. #1
    Registered User
    Join Date
    06-28-2006
    Posts
    3

    Referencing a cell based on the value in another cell

    Hi all,

    I have issues. What I want to do, if possible, is reference a particular cell by using the value in another cell. So for example, if I have the following:


    A B C
    1 9 3
    2 8
    3 7
    4 6
    5 5 =WhatIWant


    What I want to be able to do is have another cell somewhere else that will reference one of the cells A1:5, and that cell is determined by cell C1. So as it is above, WhatIWant should equal the value in A3 because C1=3, but if I change C1 to a different number, WhatIWant should change as well.

    Any ideas?

  2. #2
    Biff
    Guest

    Re: Referencing a cell based on the value in another cell

    Hi!

    Try one of these:

    =INDEX(A1:A5,C1)

    =INDIRECT("A"&C1)

    You might want to make sure C1 has a value entered into it:

    =IF(C1="","",INDEX(A1:A5,C1))

    =IF(C1="","",INDIRECT("A"&C1))

    Biff

    "septillion" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Hi all,
    >
    > I have issues. What I want to do, if possible, is reference a
    > particular cell by using the value in another cell. So for example, if
    > I have the following:
    >
    >
    > A B C
    > 1 9 3
    > 2 8
    > 3 7
    > 4 6
    > 5 5 =WhatIWant
    >
    >
    > What I want to be able to do is have another cell somewhere else that
    > will reference one of the cells A1:5, and that cell is determined by
    > cell C1. So as it is above, WhatIWant should equal the value in A3
    > because C1=3, but if I change C1 to a different number, WhatIWant
    > should change as well.
    >
    > Any ideas?
    >
    >
    > --
    > septillion
    > ------------------------------------------------------------------------
    > septillion's Profile:
    > http://www.excelforum.com/member.php...o&userid=35882
    > View this thread: http://www.excelforum.com/showthread...hreadid=556762
    >




  3. #3
    Registered User
    Join Date
    06-28-2006
    Posts
    3
    Yep, that worked. Cheers, much obliged.

  4. #4
    Biff
    Guest

    Re: Referencing a cell based on the value in another cell

    You're welcome!

    Biff

    "septillion" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Yep, that worked. Cheers, much obliged.
    >
    >
    > --
    > septillion
    > ------------------------------------------------------------------------
    > septillion's Profile:
    > http://www.excelforum.com/member.php...o&userid=35882
    > View this thread: http://www.excelforum.com/showthread...hreadid=556762
    >




+ 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