Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    61

    use cell reference in text as real cell reference in formula

    I have a cell (A1) in one of my spreadsheets which has the value B501. The format of the cell is TEXT. What I now want to do is create a formula in another cell (B1) which needs to refer to the real cell B501. However I cannot make a direct link to the real cell B501 --> I have to use the text in cell A1 to be able to make the link to cell B501 but I am not sure how to do this.

    If I would put the formula =A1 in cell B1 I would of course get B501 returned, but what I actually want returned is that the value in cell B501 is returned.

    Is this possible in excel??
    Nobody dies a virgin because life screws us all!

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Use the INDIRECT function

    =INDIRECT(A1)
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2003
    Posts
    61
    thanks! this works perfectly
    Nobody dies a virgin because life screws us all!

Posting Permissions

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