+ Reply to Thread
Results 1 to 3 of 3

Combining text and cell reference with Indirect

  1. #1
    Registered User
    Join Date
    10-02-2008
    Location
    Australia
    Posts
    3

    Combining text and cell reference with Indirect

    Hi there,

    I'm trying to combine text and a cell reference using Indirect.

    Cell B1 contains the text "Region" (no quotation marks)

    In another cell I'm trying to create a reference to "Region total" (no quotation marks)

    By my limited understanding the below should work

    =INDIRECT("b1"&" total")

    But the cell returns #REF!. I've tried pretty much every combination of quotation marks around different elements of the formula I can think of.

    Cell B1 is a drop down list, don't imagine that's relevant, but it may be.

    Any help much appreciated.
    Last edited by Myname; 10-02-2008 at 11:01 PM.

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848
    The indirect formula needs a valid cell reference in a text format. Once you add the & " total" the cell reference is no longer valid. The formula that you are trying to use would be written as
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-02-2008
    Location
    Australia
    Posts
    3
    Thanks a lot

+ 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. combining text and cell references
    By oompa_l in forum Excel General
    Replies: 1
    Last Post: 06-12-2008, 04:18 PM
  2. include cell reference in graph text box
    By roland willems in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-03-2008, 04:02 PM
  3. Merging the correct number of cell rows to fit a string of wrapped text
    By iterature in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2007, 02:15 PM
  4. changing text to cell reference
    By denshen88 in forum Excel General
    Replies: 2
    Last Post: 08-09-2007, 10:18 AM
  5. Convert cell reference to text string
    By packe in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-08-2007, 09: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