+ Reply to Thread
Results 1 to 6 of 6

Using Structured Table References and Indirect Function

  1. 02-02-2016, 06:25 PM #1
    tjeasy
    tjeasy is offline
    Registered User
    Join Date
    03-17-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Using Structured Table References and Indirect Function

    Hello,

    I have created a table and would like one column to auto-populate with the data of another column depending on a drop down of column names. For example, I would like column E to mirror the data of either A, B, C, or D depending on which is selected in a drop down. I know that I could use the index function to accomplish this, but I was wondering if there is a way to do this with structured table references. For example, column E would be populated with the reference =[indirect(dropdowncelll)]. Any help would be very much appreciated.

    Thanks,
    TJ
    Reply With QuoteRegister To Reply
  2. 02-02-2016, 06:31 PM #2
    Olly
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Using Structured Table References and Indirect Function

    You can use INDIRECT - an example, with table named Table1, and your dropdown in cell A1:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...
    Reply With QuoteRegister To Reply
  3. 02-02-2016, 06:57 PM #3
    tjeasy
    tjeasy is offline
    Registered User
    Join Date
    03-17-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    Re: Using Structured Table References and Indirect Function

    This works great! Thank you!
    Reply With QuoteRegister To Reply
  4. 02-02-2016, 07:00 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Using Structured Table References and Indirect Function

    I dont like structured refs, so I often just type in the cell ref
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  5. 02-02-2016, 07:01 PM #5
    Olly
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Using Structured Table References and Indirect Function

    Quote Originally Posted by tjeasy View Post
    This works great! Thank you!
    Happy to help. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

    Quote Originally Posted by FDibbins View Post
    I dont like structured refs, so I often just type in the cell ref
    Luddite
    Reply With QuoteRegister To Reply
  6. 02-02-2016, 07:07 PM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Using Structured Table References and Indirect Function

    Careful Olly, my club is within easy reach!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cannot use structured references for tables
    By aliceinwonderland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2018, 01:29 PM
  2. Structured references for Pivot Table?
    By Cam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-15-2015, 01:33 AM
  3. [SOLVED] Issue with nested IF function and structured references
    By jason1983 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-28-2015, 08:13 PM
  4. VBA / Structured Table References
    By carlyman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-08-2014, 06:11 AM
  5. Help with structured references
    By hellur_kitty in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-07-2013, 10:50 PM
  6. Structured Table References: What is [#Data]?
    By badaboom55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2010, 06:31 PM
  7. Excel 2007 - Table - Structured References
    By treebeard in forum Excel General
    Replies: 0
    Last Post: 03-03-2010, 03:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1