+ Reply to Thread
Results 1 to 2 of 2

Use Index Match or other function to consolidate values from list with varying references

  1. #1
    Registered User
    Join Date
    03-21-2016
    Location
    Boulder, CO
    MS-Off Ver
    2013
    Posts
    3

    Use Index Match or other function to consolidate values from list with varying references

    Hello, I'd like to figure out a formula that will consolidate values of lines belonging to the
    same family in table 1(see attached excel sheet) and pull that sum into the respective line in table 2. I will constantly be
    adding new names to table 1, inserting rows, etc. so do not want this to throw off the
    formula. Can you please advise on a good way to do this? I have a complele list of
    Family Names (like those in table 2) which will not change, as well as a complete list
    of Account names (Table 1) that also will not change. These sheets are also located in
    different workbooks.

    Thanks!
    Vijay

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,961

    Re: Use Index Match or other function to consolidate values from list with varying referen

    with text to column with a space as seperator.

    after that a pivot table.

    see the attachment.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Replies: 5
    Last Post: 02-18-2017, 11:21 AM
  2. Replies: 5
    Last Post: 01-30-2015, 06:39 PM
  3. [SOLVED] Match Issue - Consolidate Columns of Data With Match/Index/etc?
    By excelsior123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2014, 05:14 PM
  4. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  5. index/match for varying prices!
    By bruno08102013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2014, 12:10 PM
  6. index/ match on varying criteria
    By tim hem in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2013, 09:00 AM
  7. Index and Match Unique values from list
    By thelegazy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2013, 02:49 AM

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