TechRepublic|Forums|Desktop

Desktop

General discussion

  • Creator
    Topic
  • November 10, 2004 at 9:37 am #2285333

    excel names

    Locked

    by aortega · about 18 years, 7 months ago

    Is it possible to use as a reference to a named cell the contents of other cells?
    Cell A1 has been named as “lt”, and A2 has lt as cell content. May I use in A3 a formula such as
    =UnknownFunction(A2)
    to get the contents of cell A1?
    Thanks.

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • November 10, 2004 at 10:29 am #3313609

      =INDIRECT(A2)

      by wordworker · about 18 years, 7 months ago

      In reply to excel names

      This is the one you want. It looks at whatever is in the cell you specify and if that cell contains a valid range name, then the INDIRECT function will return the value in the cell with that range name.

      If the range name spans two or more cells, INDIRECT() by itself won’t work. But say “it” is the name assigned to A1:A2, and A3 contains the word “it.” Then =SUM(INDIRECT(A3)) will return the SUM of the values in the cells named by A3.

  • Author
    Replies
Viewing 0 reply threads