+ Reply to Thread
Results 1 to 3 of 3

Index / Match - match 3 input values and return the results from the index

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    West Hartford, CT
    MS-Off Ver
    Excel 2013
    Posts
    8

    Index / Match - match 3 input values and return the results from the index

    Index / Match - match 3 input values and return the results from the index
    I would like the user to input 3 values and return the result from the array. I have tried using index/match but I can't get it to work.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    Re: Index / Match - match 3 input values and return the results from the index

    May I ask why?

    You might want to make it so there are inter-related dropdown boxes instead, or something along those lines.

    It seems a little silly to me that if you know all three values, you simply don't use the filter feature of excel. Try highlighting your headers, and pressing CTRL+SHIFT+L, then click the drop down arrows and enter your data into the search box. It will filter everything that is not those values.

    You can make inter-related drop down arrows like I mentioned, but that is quite complicated, I can probably try walking you through the process (or do it myself) if that sounds like something you'd be interested in.

    You need to at least have data validation so they cannot enter values not in your lists. I require more information on what your goal is with this sheet to suggest the best route though.

    Also, why is the thread marked as solved?

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Index / Match - match 3 input values and return the results from the index

    Try this array formula**:

    =INDEX(D9:D56,MATCH(1,(A9:A56=B1)*(B9:B56=B2)*(C9:C56=B3),0))

    ** array formulas need to be entered using the key
    combination of CTRL,SHIFT,ENTER (not just ENTER).
    Hold down both the CTRL key and the SHIFT key
    then hit ENTER.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Index/Match Formula to return multiple results
    By MikeSta4ord in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-11-2015, 11:32 AM
  2. [SOLVED] Vlookup/index/match to return all values that match
    By Asil01 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-09-2014, 12:49 PM
  3. [SOLVED] SUM(IF(INDEX(MATCH()))) Confusion to return multiple results and count how many
    By athickett in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-06-2014, 02:46 PM
  4. Using Index/Match to return multiple values for one match
    By superboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2014, 06:21 PM
  5. VLOOKUP/INDEX/MATCH to return all values that match
    By lijia00 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 11:56 AM
  6. Using Index And Match To Return Potential Multiple Results To One Cell
    By jcaynes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-11-2013, 10:41 AM
  7. Can Index or Match return multiple results?
    By waverider in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-30-2007, 10:06 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