+ Reply to Thread
Results 1 to 2 of 2

Indirect with Formatted Tables (single cell reference)

  1. #1
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    154

    Indirect with Formatted Tables (single cell reference)

    Hi --

    Is it possible to create an indirect formula referencing only a single cell within a formatted table?

    I have a table with rates by month, and I want a column that always shows the rates for whatever month is input in a cell.

    The headers are in YYYY-MM format.

    Example: If I wanted the column to pull the rates from the 2018-08 column, the normal formula would be '=[@[2018-08]]'.
    However, when I try to make this an indirect formula (with the '2018-08' referenced in cell B2, lets say), I get an error.

    Is there a way to make this work?

    (fyi, each line has a unique value in column [Person]; just in case you think there's a different way to get to what I'm looking for, vs just a single cell reference)

    Thank you!

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    5,965

    Re: Indirect with Formatted Tables (single cell reference)

    I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

    To upload an Excel workbook, follow these steps:
    1) Click on "Go Advanced"
    2) Click on "Manage Attachments"
    3) Click on "Choose File"
    4) Choose your file and click on "Open"
    5) Click on "Upload"
    6) Click on "Close this window"

+ 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. Indirect Sheet reference with cell reference left function and text
    By teststrip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2015, 10:31 AM
  2. [SOLVED] =INDIRECT, Sheet reference with Incremental cell reference
    By Deap in forum Excel General
    Replies: 4
    Last Post: 06-16-2014, 05:58 AM
  3. [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
  4. [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
  5. [SOLVED] How to paste multiple paragraphs of formatted text into a single cell.
    By thejucsc@gmail.com in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 12:58 PM
  6. How to paste multiple paragraphs of formatted text into a single cell.
    By thejucsc@gmail.com in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 12:53 PM
  7. Indirect reference and worksheets with single quote in the name
    By ted_thompson61 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-27-2005, 03:05 PM

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