Results 1 to 6 of 6

Index & Match Formula with Unique Values bases on a criteria

Threaded View

Neilesh Kumar Index & Match Formula with... 03-23-2017, 01:45 PM
CK76 Re: Index & Match Formula... 03-23-2017, 02:15 PM
Neilesh Kumar Re: Index & Match Formula... 03-24-2017, 05:44 AM
canapone Re: Index & Match Formula... 03-24-2017, 05:52 AM
Neilesh Kumar Re: Index & Match Formula... 03-24-2017, 06:00 AM
canapone Re: Index & Match Formula... 03-24-2017, 06:22 AM
  1. #4
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Index & Match Formula with Unique Values bases on a criteria

    Hi,

    I'm exploiting Ck76's job.

    In B4

    =IFERROR(IFERROR(INDEX(Forecast!$B$3:$B$9,MATCH(0,IF($B$3=Forecast!$C$3:$C$9,COUNTIF($B$3:B3,Forecast!B$3:$B$9),""),0)),INDEX(Actual!$B$3:$B$9,MATCH(0,IF($B$3=Actual!$C$3:$C$9,COUNTIF($B$3:B3,Actual!$B$3:$B$9),""),0))),"")


    In B11

    =IFERROR(IFERROR(INDEX(Forecast!$B$3:$B$9,MATCH(0,IF($B$10=Forecast!$C$3:$C$9,COUNTIF($B$10:B10,Forecast!B$3:$B$9),""),0)),INDEX(Actual!$B$3:$B$9,MATCH(0,IF($B$10=Actual!$C$3:$C$9,COUNTIF($B$10:B10,Actual!$B$3:$B$9),""),0))),"")


    Formulae need array status before to be copied down.

    Regards
    Attached Files Attached Files
    Last edited by canapone; 03-24-2017 at 05:56 AM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-03-2017, 08:40 AM
  2. [SOLVED] Using INDEX MATCH to return unique values for non-unique search term
    By rico_suave in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-03-2015, 01:53 AM
  3. [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
  4. [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
  5. Replies: 0
    Last Post: 07-08-2014, 09:51 AM
  6. Index and Match 2 criteria 1 unique value
    By kosmonautas in forum Excel General
    Replies: 2
    Last Post: 05-17-2012, 03:16 AM
  7. Macro to remove duplicates values and keep unique values bases on multiple criteria
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2011, 04:37 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