+ Reply to Thread
Results 1 to 4 of 4

return multiple values in 1 column via index / match

  1. #1
    Forum Contributor
    Join Date
    08-10-2006
    Location
    The Netherlands
    MS-Off Ver
    Office for Mac 2016; MS Office 2016 for Windows
    Posts
    110

    return multiple values in 1 column via index / match

    Hi All,

    I'm searching through the forum for a solution of the below, but can't find it so far...

    Attached sheet has a data tab and an invoice tab.

    What I need is a formula in the Invoice tab in the blue cell B8 which looks up the value of the Invoice tab cell B3 in the Data tab column B and returns the sum of all values in column C.

    So when I enter "October/2013" in B3, it should return "55" in cell B8.
    When I enter "November/2013" in B3, it should return "60" in cell B8.

    Seems pretty straight forward with some index / match formula, but somehow I'm stuck in getting the sum of all values...

    Any ideas on this?

    Many thanks!!
    Peter
    invoice template.xlsx

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: return multiple values in 1 column via index / match

    In B8 Cell of Invoice Sheet

    =SUMIF(data!B:B,B3,data!C:C)

  3. #3
    Forum Contributor
    Join Date
    08-10-2006
    Location
    The Netherlands
    MS-Off Ver
    Office for Mac 2016; MS Office 2016 for Windows
    Posts
    110

    Re: return multiple values in 1 column via index / match

    Damn, that was so easy I overlooked that one....

    Many thanks!
    Case closed!
    Star added...

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: return multiple values in 1 column via index / match

    Glad it helps you and thanks for the feedback and rep

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Match index from multiple spreadsheets-Return sum of values
    By Bravo33 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2013, 02:03 PM
  2. Need to look up a value and return multiple values-INDEX/MATCH?
    By abigail99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-03-2012, 10:05 AM
  3. [SOLVED] Formula (VLOOKUP vs INDEX & MATCH) to return multiple values in the same column
    By wfidler in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2012, 07:04 PM
  4. Replies: 2
    Last Post: 07-17-2012, 11:53 AM
  5. [SOLVED] How to use Index Match to return multiple values
    By pingpoeng in forum Excel General
    Replies: 2
    Last Post: 04-09-2012, 09:58 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