+ Reply to Thread
Results 1 to 3 of 3

indirect function bug found?

Hybrid View

  1. #1
    Registered User
    Join Date
    03-03-2015
    Location
    Manila, Philippines
    MS-Off Ver
    MS2007, MS2010
    Posts
    1

    Question indirect function bug found?

    Hi,
    This is my first post in this forum.

    I am using excel 2010 at office an i accidentally notice an "unusual" bug when using indirect function.

    You see, i created several sheets named... a1_strip, b1_strip, c1_strip, d1_strip, and so on.

    when I use the indiect function:
    =indirect("a1_strip" & "!f2")
    it works ok... and so when i reference b1_strip, and d1_strip sheets.

    but when I use
    =indirect("c1_strip" & "!f2")

    it yields !REF error.
    I tried several sheet name combination... c1_bar, c1_sfs, c1_etc and c1_
    it also have same !REF error.

    sheet named c1 is ok.

    I wonder why... can you explain it?

    Thanks.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: indirect function bug found?

    C/c and R/r are used as a shorthand for selecting a row or column for the currently selected cell and i think it is evaluating as a range/reference.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: indirect function bug found?

    Try enclosing the sheet name in single quotes.
    Formula: copy to clipboard

    =INDIRECT("'c1_strip'" & "!f2")
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] INDIRECT Function with multiple sheets - SUMIF, INDIRECT & MATCH
    By DJDRU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 08:42 AM
  2. [SOLVED] Combining Text Function with Indirect Function
    By ninmjj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2013, 10:34 AM
  3. Sumif function using indirect function and data from different sheet
    By pronky007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2013, 12:40 PM
  4. [SOLVED] Using ROW function inside of both an Indirect and Index function returns #VALUE
    By xandermacleod in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-11-2012, 06:22 PM
  5. MATCH function within INDIRECT function not working
    By mgerada in forum Excel General
    Replies: 2
    Last Post: 09-04-2011, 08:37 AM

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