Results 1 to 3 of 3

INDEX with second criteria

Threaded View

  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:
    =IFERROR(INDEX($A$2:$A$10,SMALL(IF($C$2:$C$10=$S$1,ROW($A$2:$A$10)),ROW(1:1))-1,1),"")
    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

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