+ Reply to Thread
Results 1 to 4 of 4

Match 2 criteria and display value from another cell

  1. #1
    Registered User
    Join Date
    08-20-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Match 2 criteria and display value from another cell

    Hi,
    I want to search through two rangea and match two criteria, then display text from an adjacent cell from the first time that match it successful.

    Have attached an example of the spreadsheet.
    Looking to match a value in range B2:B23 to a value in D2:D23 and when there is a match (there may be multiple matches) display the text in an adjacent cell (range f2:f23) from the first time that match it successful.
    Have given an example of the values I am looking for located in L7, L8 & L9

    Thanks
    Attached Files Attached Files
    Last edited by Jose Bug; 11-26-2020 at 10:06 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: Match 2 criteria and display value from another cell

    You can use this array* formula in cell L7:

    =INDEX($F$2:$F$23,MATCH(1,($B$2:$B$23=K7&"")*($D$2:$D$23=J7),0))

    *Note than array formula needs to be confirmed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual Enter.

    Copy down as required.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    08-20-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Match 2 criteria and display value from another cell

    Legend.
    worked like a charm!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: Match 2 criteria and display value from another cell

    Glad to help - thanks for the rep.

    Pete

+ 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] Display cell data if multiple criteria match
    By A.Walloper in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-03-2020, 06:50 PM
  2. Replies: 7
    Last Post: 03-04-2020, 12:27 PM
  3. Replies: 1
    Last Post: 10-06-2017, 05:02 PM
  4. [SOLVED] How to nest formula MATCH , ROW to display multiples criteria
    By Franky alta in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-13-2015, 10:20 PM
  5. Replies: 3
    Last Post: 02-07-2014, 03:01 AM
  6. Replies: 3
    Last Post: 07-26-2013, 06:46 PM
  7. Display 'UNKNOWN' in a cell if the criteria doesn't match
    By famico78 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2008, 09:55 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