+ Reply to Thread
Results 1 to 5 of 5

Index Match Using MULTIPLE CRITERIA

  1. 07-15-2023, 11:06 AM #1
    jackoooooo
    jackoooooo is offline
    Registered User
    Join Date
    06-21-2011
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    20

    Index Match Using MULTIPLE CRITERIA

    Hi all , I am unable to make this formula work , any idea?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-15-2023, 11:12 AM #2
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,005

    Re: Index Match Using MULTIPLE CRITERIA

    Your formula is array formula. Committed your formula with Ctrl+Shift+Enter.
    Reply With QuoteRegister To Reply
  3. 07-15-2023, 11:14 AM #3
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Index Match Using MULTIPLE CRITERIA

    Also take the @ symbols out of the formula.

    BSB
    Reply With QuoteRegister To Reply
  4. 07-15-2023, 11:32 AM #4
    jackoooooo
    jackoooooo is offline
    Registered User
    Join Date
    06-21-2011
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Index Match Using MULTIPLE CRITERIA

    Quote Originally Posted by windknife View Post
    Your formula is array formula. Committed your formula with Ctrl+Shift+Enter.
    Thank you, it's work
    Reply With QuoteRegister To Reply
  5. 07-15-2023, 11:42 AM #5
    windknife
    windknife is offline
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,005

    Re: Index Match Using MULTIPLE CRITERIA

    You are welcome.
    --------------------------------------
    If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] Need Index Match (Maybe Vlookup Match?) to support Multiple Criteria
    By hchavous in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-31-2022, 10:28 AM
  2. [SOLVED] Index Match help for multiple criteria match in a range of cells
    By GordonKy42 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-01-2021, 08:50 AM
  3. VBA function to match multiple criteria faster than vlookup or index match
    By bkav1991 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-09-2020, 09:14 AM
  4. Index match with multiple criteria when one criteria requires to exclude values from searc
    By adsako in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2020, 08:06 AM
  5. Index Match based on multiple Match criteria that returns each subsequent occurence.
    By punkrocksock in forum Excel General
    Replies: 1
    Last Post: 03-01-2020, 10:36 PM
  6. Need help in Index, Match usage to match multiple criteria in sum function
    By Summer0830 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2017, 02:47 AM
  7. Formula needed for partial string match as part of index match with multiple criteria
    By Marvelous in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2014, 04:34 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1