Results 1 to 5 of 5

INDEX-MATCH with Multiple Row Criteria?

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    MS365
    Posts
    80

    INDEX-MATCH with Multiple Row Criteria?

    I'm trying to run an INDEX-MATCH-MATCH to pull store sales by month but my months and store accounts are in rows, not columns (see attached sample) and as far as I understand, one MATCH relates to rows and the other to columns. I'm ideally trying to do an INDEX(value, MATCH(row criteria #1, MATCH(row criteria #2. Please advise.

    The real data has over 10K rows, so I'm looking for a formula where I can plug-and-play in 5 minutes (I'll have to be doing this regularly).

    Thanks in advance for any help...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 03-25-2020, 08:06 AM
  2. Replies: 1
    Last Post: 03-01-2020, 10:36 PM
  3. INDEX MATCH from table with multiple MATCH criteria
    By nostrum in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-30-2019, 11:41 AM
  4. Replies: 16
    Last Post: 01-05-2018, 11:04 PM
  5. Need help in Index, Match usage to match multiple criteria in sum function
    By Summer0830 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2017, 02:47 AM
  6. Index/Match to Match entries on multiple criteria
    By manning457 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2015, 02:32 PM
  7. Replies: 2
    Last Post: 09-27-2014, 04:34 PM

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