Results 1 to 9 of 9

Index Match with Multiple Criteria (incl. wildcard)

Threaded View

  1. #1
    Registered User
    Join Date
    10-26-2021
    Location
    France
    MS-Off Ver
    2013
    Posts
    20

    Index Match with Multiple Criteria (incl. wildcard)

    HI Guys

    I am trying to use the INDEX MATCH based on multiple criteria including a wildcard (partial text and an *).
    In the attached excel file, the main data is in the PROD tab.
    I am trying to summarise this data in the Prod summary tab but I am having problems working out the formulas for the columns in orange.

    I wish to know for each of the different packaging formats (Gn 1/3, bol, verrine) when the first and last product of each format was produced for each day.
    I have put in formulas for the first and last products of the day but when I try to adapt these formulas to include the packaging type (Gn 1:3, bol, verrines, etc) I receive a N/A message. ;-(

    I would really appreciate your help to assist me in understanding what I am doing wrong

    Many thanks

    Chris
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index Match with Multiple Criteria (incl. wildcard & greater than a value)
    By chrisou in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-26-2021, 10:34 AM
  2. Power BI - Wildcard - count partial match with multiple criteria
    By thomasuponor in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-27-2021, 03:01 AM
  3. [SOLVED] Index Match multiple criteria with wildcard
    By Perk1961 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-29-2020, 12:07 PM
  4. [SOLVED] Index match with multiple criteria (one with a wildcard) and multiple results.
    By rachelsteele in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-03-2019, 06:51 PM
  5. [SOLVED] INDEX - MATCH on two Criteria with wildcard
    By SrDurham in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2015, 09:04 AM
  6. [SOLVED] SUMIFS, multiple criteria incl. unique values
    By rinkjames in forum Excel General
    Replies: 7
    Last Post: 06-16-2012, 07:15 PM
  7. Count rows with multiple criteria incl max date
    By johnnyr1ngo in forum Excel General
    Replies: 3
    Last Post: 11-30-2010, 12:44 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