Results 1 to 8 of 8

Filter and extract list of data based on criteria using INDEX MATCH

Threaded View

  1. 03-13-2018, 05:43 AM #1
    brake
    brake is offline
    Registered User
    Join Date
    01-08-2017
    Location
    Malang, Indonesia
    MS-Off Ver
    2013
    Posts
    29

    Filter and extract list of data based on criteria using INDEX MATCH

    Hi anybody,

    I need help, i gave up to find the formula....

    How to filter and extract data based on criteria..... like so :

    filterIndexMatch.JPG

    i want the formula in cell J2, K2 and L2 based on criteria in H2, H3, and H4....

    Thank You for any help, or suggested link given....


    Attached Files Attached Files
    Last edited by brake; 03-13-2018 at 06:11 AM. Reason: adding title to make it clear
    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. [SOLVED] Extract a list based on criteria within same & adjacent column
    By Ariff_Chowdhury in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-20-2017, 12:16 AM
  2. Extract Unique List Based on multiple criteria
    By Herbiec09 in forum Excel General
    Replies: 7
    Last Post: 01-14-2017, 07:23 AM
  3. Extract List Based on multiple criteria
    By Herbiec09 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-14-2017, 04:21 AM
  4. [SOLVED] Extract a sublist from a list based on criteria(s)
    By hcyeap in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-01-2015, 05:16 PM
  5. extract data based on four criteria in excel sheet or VBA code to extract
    By navanee in forum Excel General
    Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  6. [SOLVED] Extract entire rows from list based on criteria
    By Test123Test in forum Excel General
    Replies: 5
    Last Post: 04-29-2013, 09:28 AM
  7. Filter List Based On Certain Criteria
    By Scott_88 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-17-2012, 08:49 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