+ Reply to Thread
Results 1 to 3 of 3

trying to make INDEX(MATCH) with multiple text values to return.

  1. #1
    Registered User
    Join Date
    09-12-2019
    Location
    United States
    MS-Off Ver
    2016
    Posts
    2

    trying to make INDEX(MATCH) with multiple text values to return.

    I'm having trouble making an INDEX MATCH function that can look for either phrase in the MATCH value for column headings, not both, either or. This is the formula.

    =IF(A10=0,"",INDEX('PMI Gun Data "Paste Here"'!$A$1:$BZ$1000,MATCH(A10,'PMI Gun Data "Paste Here"'!$A:$A,0),MATCH("Alloy1",'PMI Gun Data "Paste Here"'!$1:$1,0)))

    I want to add "Match #1" to "Alloy1" in the second MATCH function and have it search for one or the other.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365, rarely 2007
    Posts
    12,717

    Re: trying to make INDEX(MATCH) with multiple text values to return.

    Tvboy676
    1. Welcome to the forum.
    2. Regional differences matter. Please edit your profile to show a meaningful location. Canada, USA, UK ... etc suffices
    3. Please attach an Excel workbook representative of what you have and desired output ... including layout(s).

    Of note: The 'paperclip' icon has not worked for some time. So please save yourself some grief.
    To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

    be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”
    The file name will appear at the bottom of your reply.
    Dave

  3. #3
    Registered User
    Join Date
    09-12-2019
    Location
    United States
    MS-Off Ver
    2016
    Posts
    2

    Re: trying to make INDEX(MATCH) with multiple text values to return.

    Added copy of file being worked with.
    Attached Files Attached Files
    Last edited by Tvboy676; 09-13-2019 at 08:32 PM.

+ 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. Return Multiple Match Values in Excel Using INDEX-MATCH
    By chris1089 in forum Excel General
    Replies: 10
    Last Post: 06-15-2017, 09:25 AM
  2. [SOLVED] Match Index to return multiple values
    By ed4ed2ed in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-13-2015, 05:55 PM
  3. 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
  4. Match index from multiple spreadsheets-Return sum of values
    By Bravo33 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2013, 02:03 PM
  5. Need to look up a value and return multiple values-INDEX/MATCH?
    By abigail99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-03-2012, 10:05 AM
  6. Replies: 2
    Last Post: 07-17-2012, 11:53 AM
  7. [SOLVED] How to use Index Match to return multiple values
    By pingpoeng in forum Excel General
    Replies: 2
    Last Post: 04-09-2012, 09:58 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