+ Reply to Thread
Results 1 to 2 of 2

Index/Match to Return 1D array to be used in a sumproduct

  1. #1
    Registered User
    Join Date
    12-30-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    39

    Index/Match to Return 1D array to be used in a sumproduct

    Hi guys,

    I would like to calculate a weighted average using sumproduct. The issue is the databases I am pulling from are asymmetrical. Essentially what I want to do is do an index/match that returns an array (1 row of data) which is based off of two criteria, location and date. I already know how to perform a 2 criteria index/match using &, but I am not sure how to make the return of the index/match be an array versus a single cell.

    I have attached a simplified version of my data. My actual data has hundreds of rows so the formula is not trivial.

    Thanks in advance!

    David
    Attached Files Attached Files

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    Re: Index/Match to Return 1D array to be used in a sumproduct

    M
    N
    O
    3
    A Jan
    #N/A
    4
    A Feb
    3700
    5
    A Mar
    5000
    6
    B Jan
    #N/A
    7
    B Feb
    5650
    8
    B Mar
    4500


    In O3, confirmed with Ctrl+Shift+Enter,

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

+ 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: 6
    Last Post: 04-30-2014, 02:42 AM
  2. Replies: 4
    Last Post: 03-27-2014, 01:09 PM
  3. Use Index/Match Function to Return Values from an Array
    By 00pumpkin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2013, 02:22 PM
  4. Match/Index array in VBA to return cell address
    By djhsickboy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2011, 02:18 AM
  5. Replies: 2
    Last Post: 02-27-2010, 11:17 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