+ Reply to Thread
Results 1 to 2 of 2

Variants on Structured References i.e. [@Header]

  1. #1
    Registered User
    Join Date
    11-29-2010
    Location
    Nashville
    MS-Off Ver
    2010
    Posts
    76

    Variants on Structured References i.e. [@Header]

    Hello,

    I'm trying to figure out how to make structured references work in my use case.

    I'm liking the default use of structured references in Excel, it seems to help me avoid running into #REF problems. However, I have a formula in an Excel column that to pull data from the row below rather than the current row in a given circumstance (the reason for this is that I've got VERY unstructured data that I'm making structured through all these formulas).

    Here's a simplified version of what I was doing:

    A | B | C
    Content1 | =A2+# | =if(B2>#,A2,A3)
    Content2 | =A3+# | =if(B3>#,A3,A4)

    Here's a simplified version of using the structured references:

    ColA | ColB | ColC
    Content1 | =[@ColA]+# | if([@ColB]>#,[@ColA],A3)
    Content2 | =[@ColA]+# | if([@ColB]>#,[@ColA],A4)

    As you may be able to see, it gets cleaner in that the need for and risk of specific references is mostly ommitted, but I want to carry that through all the way to the final term, which is currently still a specific reference.

    I want to say something along the lines of [@ColA]+1 so it will look down one row, but I know that won't work. What will?

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Variants on Structured References i.e. [@Header]

    OFFSET is probably what you are looking for. Something like this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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] Cannot use structured references for tables
    By aliceinwonderland in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-09-2018, 01:29 PM
  2. Help with structured references
    By hellur_kitty in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-07-2013, 10:50 PM
  3. [SOLVED] Structured references in vlookup functions
    By Simon.Ward in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2013, 09:56 AM
  4. Structured Table References: What is [#Data]?
    By badaboom55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2010, 06:31 PM
  5. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1