+ Reply to Thread
Results 1 to 2 of 2

formula index / match issues when then there are duplicates

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    formula index / match issues when then there are duplicates

    I have a workbook with 2 sheets packing and invoice .

    The sheet packing have a breakdown of bottles in column E .

    The sheet Invoice needs to be reconcile with packing sheet. as criteria Invoice and reference header .

    I have tried to concatenate with index and match but falls shorts when there are duplicates with same invoice and reference but diffferent packing.

    The formula takes the first one he finds.

    In yellow issue with formula not giving correct answer

    Can anyone assist,
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: formula index / match issues when then there are duplicates

    Please try at E2 and copy down

    =IFERROR(INDEX(packing!E:E,AGGREGATE(15,6,ROW(packing!$C$2:$C$18)/(packing!$C$2:$C$18=C2),COUNTIFS(C$2:C2,C2))),"")
    Attached Files Attached Files

+ 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. Index Match issues
    By CoachK88 in forum Excel General
    Replies: 6
    Last Post: 08-23-2018, 10:38 AM
  2. Index and Match issues
    By Eric Tsang in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 02-09-2016, 01:09 PM
  3. [SOLVED] Index and Match issues
    By Wikster7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2016, 04:52 AM
  4. index match issues
    By carrollkm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-23-2014, 12:56 AM
  5. [SOLVED] Problem Using LARGE formula with Index/Match to pull values when there are Duplicates
    By BDavis in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-11-2014, 02:23 PM
  6. [SOLVED] Index/Match issues
    By xxQueenxo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-25-2014, 12:56 AM
  7. Issues with Index Match formula returning values and some #ref
    By kokapelly in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 04:47 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