+ Reply to Thread
Results 1 to 3 of 3

INDEX with second criteria

  1. #1
    Forum Contributor
    Join Date
    12-24-2018
    Location
    Oregon, USA
    MS-Off Ver
    2010
    Posts
    104

    INDEX with second criteria

    I have the following formula that I'd like to expand on:
    Please Login or Register  to view this content.
    Currently it matches value in S1, I'd like to also match value in S2.
    Last edited by Grizraz; 01-06-2020 at 04:25 AM. Reason: correction

  2. #2
    Forum Contributor
    Join Date
    12-24-2018
    Location
    Oregon, USA
    MS-Off Ver
    2010
    Posts
    104

    Re: INDEX with second criteria

    This now works with the following:
    Please Login or Register  to view this content.
    My next goal is to add two more conditions with different ranges:
    Please Login or Register  to view this content.
    This formula however is not working?
    S4 has value of *p (WILDCARD p)
    S5 has value of *F (WILDCARD F)

    Is this possible?

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: INDEX with second criteria

    "Is this possible?"
    I don't believe that it is, however if you would like for us to look for a way to accomplish the goal, please follow the instructions in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Combining INDEX/MATCH with several criteria and INDEX/SMALL
    By Dresas in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-15-2018, 11:02 AM
  2. [SOLVED] Index Match with multiple criteria and date criteria
    By snolem75 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-28-2018, 03:51 PM
  3. Replies: 16
    Last Post: 01-05-2018, 11:04 PM
  4. Single Criteria Index Match with concatenated criteria NOT WORKING
    By hassanleo1987 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 04-26-2017, 12:28 AM
  5. [SOLVED] Index and Two Match Criteria- meeting both criteria (need help to repair formula)
    By OilAndGasMan1984 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2017, 10:56 PM
  6. [SOLVED] Index Match with Multiple Criteria Using Same Criteria Column
    By rominjn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2015, 11:34 AM
  7. Index Match using two criteria to return on of criteria values
    By RogueLeader in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2014, 09:50 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1