Results 1 to 5 of 5

Indirect Substtitute not working

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365 Version 2501 64-bit
    Posts
    1,474

    Indirect Substtitute not working

    DropList in C2 lists the Models in Col I (e.g. "Connect V408"), which have spaces in the names, so is named in the formula as "Connect_V408".

    Cols J and K have derivates for each model (e.g. "GRAND TOURNEO") which have spaces in the names, so are named in the formula as "GRAND_TORNEO".

    DropList in C4 SHOULD list the derivates for the choice in C2, using =INDIRECT(SUBSTITUTE(C2,"_"," ")), but isn't working.

    Appreciate anyone who can set me right, as don't remember this problem before?

    Ochimus
    Attached Files Attached Files
    Last edited by Ochimus; 09-16-2017 at 02:31 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. INDIRECT Formula is not working
    By ImranBhatti in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-26-2017, 12:39 PM
  2. iferror / indirect substitute not working?
    By nimv1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2016, 09:33 PM
  3. [SOLVED] Indirect Function Not working
    By dobracik in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-16-2016, 07:05 PM
  4. Indirect drop down list not working
    By Narelles in forum Excel General
    Replies: 3
    Last Post: 12-18-2013, 09:16 PM
  5. [SOLVED] Indirect function not working with spaces
    By exarranum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 12:30 AM
  6. indirect not working
    By martindwilson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2007, 08:56 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