+ Reply to Thread
Results 1 to 3 of 3

Double match and index

  1. #1
    Registered User
    Join Date
    03-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    2

    Double match and index

    Hi All,

    This is my first post as this is the first time I couldn't find an anwser already posted
    I'm trying to validate 2 cells and if both matches it should return a value from column 3
    I've gotten so far as it would return a error when criterea is not met.
    However is it finds a match it always returns the first value.
    My current formula is: =INDEX($C$24:$C$29,(AND(MATCH(A12,$A$24:$A$29,1),MATCH(B12,$B$24:$B$29,0))))

    I can't find a way to make Excel validate the first 2 columns and return the value from column 3.
    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Double match and index

    Try in C11:

    =IFERROR(LOOKUP(2,1/(SEARCH($A$24:$A$26,A11)+SEARCH($B$24:$B$26,B11)),$C$24:$C$26),"NOT FOUND")
    Quang PT

  3. #3
    Registered User
    Join Date
    03-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Double match and index

    Awsome!
    It works perfectly.
    Thanks a lot!

+ 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. Double layered INDEX/MATCH?
    By kuni-d in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-09-2014, 11:01 AM
  2. [SOLVED] INDEX MATCH SMALL ROW, Double criteria Lookup
    By GP_SRT in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-22-2013, 11:15 AM
  3. Double lookup or index and match?
    By dan_manchester in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2013, 09:01 AM
  4. VBA - Index double match and insert values in range
    By Biinge in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-02-2011, 02:43 PM
  5. Double VLookup or INDEX MATCH or something else?
    By carlwin in forum Excel General
    Replies: 5
    Last Post: 06-20-2010, 08:00 PM

Tags for this Thread

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