Results 1 to 5 of 5

INDEX MATCH Multiple Output with Partial Match

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2014
    Location
    USA
    MS-Off Ver
    2013
    Posts
    28

    INDEX MATCH Multiple Output with Partial Match

    Hi everyone,

    I was working on a spreadsheet where I was able to match a user input to a table and output multiple values.
    If the user types in a name, it will output the value that is in an adjacent column. The name may occur multiple times, and I was able to resolve this using the SMALL(IF()) function nested within an INDEX MATCH.

    My next step was my attempt to use wildcards within the array and this did not work. In the example if I type in "Illi ", hopefully I was trying to have the function output 7, 9, 10. These outputs correspond to an input of "Illinois X".

    I tried things such as "*" & J16 & "*" inside my original function as well as some new functions but none seem to work. Thank you for any help!

    Ray
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. finding partial text in an index match formula
    By garyaw in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-30-2015, 04:27 PM
  2. Replies: 1
    Last Post: 06-18-2015, 08:45 AM
  3. INDEX Partial MATCH and Total
    By flapface in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-18-2014, 10:22 AM
  4. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  5. [SOLVED] Trying to match partial string to an array, need to output related cell
    By vijaijohn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-23-2013, 03:04 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