Results 1 to 10 of 10

Indirect() syntax problem

Threaded View

1eyedjack Indirect() syntax problem 04-23-2010, 04:24 AM
DonkeyOte Re: Indirect() syntax problem 04-23-2010, 04:44 AM
1eyedjack Re: Indirect() syntax problem 04-23-2010, 04:57 AM
DonkeyOte Re: Indirect() syntax problem 04-23-2010, 05:14 AM
1eyedjack Re: Indirect() syntax problem 04-23-2010, 05:28 AM
  1. 04-23-2010, 04:24 AM #1
    1eyedjack is offline
    Forum Contributor
    Join Date
    11-14-2007
    Posts
    142

    Indirect() syntax problem

    Can someone please help my with the syntax for a formula that returns an undesired #REF! error the way that I have written it?

    Problem is:
    A worksheet "Summary (0)" contains a table identified by local named ranges.
    Another worksheet "Sheet2" in the same workbook contains a cell which names the worksheet wherein that table resides. ie, Sheet2!$E$3 contains the text string "Summary (0)"

    Cell Sheet2!$E$5 contains a lookup value.

    Cell Sheet2:$E$11 contains a formula which should return a value from the table, but by locating the table from the sheet name contained in cell Sheet2:$E$3.

    The problem is illustrated in the attached workbook.

    The end result returned by Sheet2:$E$11 should be the same as that which is returned by the cell Sheet2!$E$9 which contains a simplified version of the formula in which the table's worksheet is hard coded into the formula. Currently cell E11 only returns #REF!.
    Attached Files Attached Files
    Last edited by 1eyedjack; 04-23-2010 at 06:21 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1