Results 1 to 7 of 7

Index & Match Formula for Unique Values On Multiple Criteria

Threaded View

  1. #5
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,992

    Re: Index & Match Formula for Unique Values On Multiple Criteria

    Try

    D24
    Formula: copy to clipboard
    =IFERROR(INDEX('Master Invoice Entry'!A$2:A$31,MATCH(1,INDEX(('Master Invoice Entry'!B$2:B$31=B$17)*('Master Invoice Entry'!C$2:C$31=N$9)+(COUNTIFS($D$23:D23,'Master Invoice Entry'!$A$2:$A$31)),),0)),"")


    Copy down!!
    Last edited by shukla.ankur281190; 04-10-2018 at 01:26 AM. Reason: Changes as per Jet Message me
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Looking for help on unique value pull with multiple criteria using Index Match
    By shinobi2u in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-09-2017, 05:07 PM
  2. [SOLVED] Index & Match Formula for Unique Values On Multiple Criteria
    By Neilesh Kumar in forum Excel General
    Replies: 2
    Last Post: 03-24-2017, 10:13 AM
  3. [SOLVED] Index & Match Formula with Unique Values bases on a criteria
    By Neilesh Kumar in forum Excel General
    Replies: 5
    Last Post: 03-24-2017, 06:22 AM
  4. Two Criteria Index Match on Multiple Sheets with Multiple Values
    By MegganM in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-21-2016, 09:51 PM
  5. [SOLVED] Index/Match with Multiple Criteria and Multiple return values
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2015, 10:27 AM
  6. Replies: 0
    Last Post: 07-08-2014, 09:51 AM
  7. [SOLVED] Two criteria Index Match on multiple sheets returning multiple values
    By Joak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 10:03 AM

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