+ Reply to Thread
Results 1 to 3 of 3

Indirect Sheet reference with cell reference left function and text

  1. #1
    Registered User
    Join Date
    05-28-2014
    Posts
    18

    Indirect Sheet reference with cell reference left function and text

    Hello All,

    I am trying to solve an Indirect function to reference a sheet that has a space and where the first part of the sheet named is located in a cell reference.

    See attached example.

    Problem - I need to extract data from sheet "JD54N Due" to insert the time maintenance is due in the trips page. My formula is in sheet "Trips" and references another cell to extract the first half of the sheet name "JD54N" from a cell containing the car and driver reference using LEFT(Find()).

    Any suggestion?Indirect with Space.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    563

    Re: Indirect Sheet reference with cell reference left function and text

    on cell c5

    Please Login or Register  to view this content.
    Click (*) if you received helpful response.

    Regards,
    David

  3. #3
    Registered User
    Join Date
    05-28-2014
    Posts
    18

    Re: Indirect Sheet reference with cell reference left function and text

    SDCH,

    That worked perfectly.

    Thank you,

+ 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, Sheet reference with Incremental cell reference
    By Deap in forum Excel General
    Replies: 4
    Last Post: 06-16-2014, 05:58 AM
  2. Reference sheet names with indirect function to make formula
    By ajeffres in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2014, 10:21 AM
  3. Replies: 4
    Last Post: 01-13-2013, 08:56 PM
  4. Indirect reference within SUMPRODUCT & LEFT
    By troop2118 in forum Excel General
    Replies: 8
    Last Post: 06-01-2012, 08:33 AM
  5. indirect function to reference cell on different sheet
    By Dolemite in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 09-06-2005, 07:05 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