+ Reply to Thread
Results 1 to 2 of 2

Help, Indirect returns #REF

  1. #1
    Registered User
    Join Date
    11-21-2009
    Location
    Rhyl, North Wales
    MS-Off Ver
    Excel 2003
    Posts
    39

    Help, Indirect returns #REF

    The Target cell is ' Pal Summary!$E$7

    i have a page named Admin which holds settings including sheet names (Admin!E7 points to a cell with the word "Pal" which is part of a sheet name).

    i tried the formula below but keep getting the #REF error even tho when evaluated the formula looks good eg ' Pal Summary!E7

    =INDIRECT("'"&Admin!E7&"' Summary!E7")

    Any ideas ?

  2. #2
    Registered User
    Join Date
    11-21-2009
    Location
    Rhyl, North Wales
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: Help, Indirect returns #REF

    Doesn't matter, solved it with

    =Indirect("'"&Admin!E7&" Summary'!E7")

+ 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