Results 1 to 10 of 10

INDIRECT when reference another list - error

Threaded View

  1. #1
    Registered User
    Join Date
    11-18-2014
    Location
    Vancouver, Canada
    MS-Off Ver
    Mac 2011
    Posts
    4

    Question INDIRECT when reference another list - error

    Hello everyone,

    I have been making my own budget in excel, one reason is to teach my self more about excel and another one is too keep track of what I'm doing with my money.

    I had this working before, I have no idea what I did to make it stop working, I looked on several tutorials and the error dosn't help me at all.
    What I'm trying to do, I pick what category my expense is, then the cell on the right side of it sense what category I picked, goes to management sheet and makes a list of corresponding list with the same name.

    When I reference my other list through Validate and I type in
    =INDIRECT($D$5)
    This is where I pick what category my expense is and it's left of this Cell where the above code is written in through Validate.

    and I get following error: "The Source is currently evaluates to an error. Do you wish to continue"
    In my head I go, well... thanks for at least trying to help me. I have looked if my names was not the same, but they are and I tried re-doing everything from scratch as well.

    When I type in following:
    =INDIRECT("RC[-1]",0)
    or
    =INDIRECT( "D" & ROW() )
    It dosn't reference the correct NameList that I have created and linked under the Management Tab, it just let me pick the same name as the left cell is.

    I hope I make myself clear and I have attached HomeBudget2014_Help.xlsx my excel sheet as well

    thanks in advance =)

    I realize that I should have post this in the Mac part, if someone can move this, that would be great! thank you =)
    Last edited by HeroBiX; 11-18-2014 at 03:18 PM. Reason: Mac Version

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] =INDIRECT, Sheet reference with Incremental cell reference
    By Deap in forum Excel General
    Replies: 4
    Last Post: 06-16-2014, 05:58 AM
  2. [SOLVED] Replace absolute cell reference with Indirect cell reference in formula
    By Roothy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2013, 04:46 AM
  3. [SOLVED] How to reference an entire row based on an indirect cell reference
    By echo_oscar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-31-2012, 08:50 PM
  4. INDIRECT to Reference Worksheets #Ref Error
    By McToons in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2011, 03:46 AM
  5. [SOLVED] dependent combo box list, with indirect reference
    By Iyue in forum Excel General
    Replies: 1
    Last Post: 02-24-2005, 07:06 PM

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