Results 1 to 2 of 2

INDEX / MATCH with duplicate cells

Threaded View

  1. 05-18-2021, 09:30 AM #1
    andrugrasu
    andrugrasu is offline
    Forum Contributor
    Join Date
    01-19-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2016
    Posts
    133

    INDEX / MATCH with duplicate cells

    Hello,
    In column O sheet test(2) i use a formula with index and match to get data from sheet Sheet2. But my formula omit duplicate cells. In sheet Sheet2 i mark with yellow the missing value. What i need to add to my formula to have the correct value?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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 Duplicate Values - ignore cells equal to 0
    By LordByron in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-23-2020, 11:49 AM
  2. [SOLVED] Index Match Duplicate Values With No Helper Cells
    By Kerik in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-23-2020, 11:28 AM
  3. Index and Match duplicate results - How to show duplicate names?
    By barman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2018, 11:28 AM
  4. Match and Index with Duplicate values
    By shortracer5 in forum Excel General
    Replies: 1
    Last Post: 09-09-2016, 05:25 AM
  5. [SOLVED] Sum Duplicate Index-match-match Values
    By djh30 in forum Excel General
    Replies: 3
    Last Post: 01-06-2015, 11:27 PM
  6. Index Match with Duplicate Values
    By js2178a in forum Excel General
    Replies: 2
    Last Post: 09-28-2014, 02:21 AM
  7. Index Match IF Duplicate
    By england79m in forum Excel General
    Replies: 4
    Last Post: 03-29-2008, 10:46 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1