+ Reply to Thread
Results 1 to 3 of 3

Indirect() formula returning #Ref error but cant see why

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    65

    Indirect() formula returning #Ref error but cant see why

    Please see attached

    Scans Info Tab, From row 30 onwards

    im using the indirect formula to reference what is displayed on row 34 as that is also the tab name

    Ive had to delete some sheets to make the attachment fit, so everything in Red highlight just ignore it

    Please help

    Thank You
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Indirect() formula returning #Ref error but cant see why

    The formula is unreadable, contains nothing but REF error, but I suspect you are referring to the cell containing the date ? If so, get rid of the merged cells, and see what happens

  3. #3
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Indirect() formula returning #Ref error but cant see why

    Did you attach the correct file? I searched the entire workbook and could not find any formulas containing the INDIRECT function.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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 Formula Causes #N/A Error
    By Steve0492 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-21-2013, 05:51 AM
  2. Problem with indirect formula and ref error
    By amartino44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2013, 07:37 PM
  3. SUMIF with INDIRECT.EXT returning #VALUE error
    By opex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2013, 10:34 AM
  4. [SOLVED] Can you please help with an INDIRECT formula error?
    By Stephen01 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-06-2012, 11:27 PM
  5. Excel 2007 : Indirect formula error.
    By as13mar in forum Excel General
    Replies: 0
    Last Post: 07-13-2012, 05:47 AM

Tags for this Thread

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