+ Reply to Thread
Results 1 to 2 of 2

Index match with multiple criteria when one criteria requires to exclude values from searc

  1. #1
    Forum Contributor
    Join Date
    05-01-2018
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    117

    Index match with multiple criteria when one criteria requires to exclude values from searc

    Hello all

    I'm trying to lookup values with multiple criteria and from results i need to exclude all values if number in column E (sheet7) = 90
    as the result I should get values with blanks or zeros or N/A in case there is number 90 in cells in column E

    I applied below formula however excel does not exclude those values (to exclude values I have used <> )

    =INDEX(Table_dg_dc01_progress_ProgressDotNet_Gear_PurchaseOrderDetail[PODetNum], MATCH(1, ([@WONo]=Table_dg_dc01_progress_ProgressDotNet_Gear_PurchaseOrderDetail[PODetWordNo])*([@WORoutOpNo]=Table_dg_dc01_progress_ProgressDotNet_Gear_PurchaseOrderDetail[PODetSubConOpNo])*(Table_dg_dc01_progress_ProgressDotNet_Gear_PurchaseOrderDetail[PODetStatus]<>"90"), 0))

    Can you please advise

    thanks
    Attached Files Attached Files
    Last edited by adsako; 03-25-2020 at 07:42 AM.

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,781

    Re: Index match with multiple criteria when one criteria requires to exclude values from s

    if 90 is a number try 90 without " "

+ 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. Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  2. Issue using Index/Match to pull multiple occurrences of "Match" criteria
    By aridfriedman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2014, 11:38 AM
  3. [SOLVED] Multiple criteria lookup - First match :exact" and second match "Closest"
    By mweichorn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2013, 12:14 PM
  4. Index/match "if not" criteria
    By jewellove in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-27-2012, 12:48 PM
  5. Replies: 10
    Last Post: 12-18-2012, 07:59 AM
  6. [SOLVED] Find multiple "text" criteria and return as ""Yes" in Matrix
    By bertrand82 in forum Excel General
    Replies: 11
    Last Post: 04-30-2012, 09:20 AM
  7. Replies: 0
    Last Post: 07-09-2009, 04:07 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