Results 1 to 4 of 4

Index and Two Match Criteria- meeting both criteria (need help to repair formula)

Threaded View

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2010
    Posts
    62

    Index and Two Match Criteria- meeting both criteria (need help to repair formula)

    I'm trying to get Cell Q385 to give me 6,647... Is my formula a bust?

    6,647 is found in cell G426 on the 'RM backlog' sheet

    =IFERROR(INDEX('RM Backlog'!$G$2:$G$1048576,MATCH($D382&Q$8,'RM Backlog'!$F$2:$F$1048576&'RM Backlog'!$E$2:$E$1048576,0)),0)
    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. [SOLVED] Delete not meeting criteria, criteria in column another sheet (Filter)
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-10-2016, 07:32 AM
  2. Sumproduct or Index, Match to list data from another sheet meeting criteria
    By teststrip in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2015, 10:01 PM
  3. [SOLVED] Count Data Meeting Criteria Across Columns Meeting Criteria
    By idelta in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-06-2015, 03:53 PM
  4. [SOLVED] Index and Match To Extract All Unique Locations Meeting Reoccurring Criteria Value
    By rlh06 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-05-2015, 11:25 AM
  5. [SOLVED] Retrieving Top 8 Values while meeting a criteria (Index / Match Formula)
    By Joseph Wee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-17-2014, 08:29 AM
  6. Lookup/match in multiple columns meeting criteria
    By ranmyaku in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-03-2013, 04:36 PM
  7. Replies: 6
    Last Post: 09-30-2009, 12:05 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