+ Reply to Thread
Results 1 to 10 of 10

Help with INDEX MATCH wildcard matching

  1. #1
    Registered User
    Join Date
    06-07-2016
    Location
    Richmond, VA
    MS-Off Ver
    365 Apps for business
    Posts
    76

    Help with INDEX MATCH wildcard matching

    In the attached example I want to return the send date (Column A) by searching for part of the value in Column B.

    So I want to search the contents of Column B for the value provided in B8, and return the value in A5.

    I'm trying to use INDEX and MATCH to do that, but it's throwing an error when I try to ask it to match on a wildcard value.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Help with INDEX MATCH wildcard matching

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-07-2016
    Location
    Richmond, VA
    MS-Off Ver
    365 Apps for business
    Posts
    76

    Re: Help with INDEX MATCH wildcard matching

    Quote Originally Posted by Fluff13 View Post
    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    That worked - thanks!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Help with INDEX MATCH wildcard matching

    You're welcome & thanks for the feedback.

  5. #5
    Forum Contributor
    Join Date
    05-11-2022
    Location
    Singapore
    MS-Off Ver
    MS 2019
    Posts
    152

    Re: Help with INDEX MATCH wildcard matching

    @Fluff13

    When Cell-B8 is blank, there is a return value (3-Aug-2022). How can we avoid this?

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Help with INDEX MATCH wildcard matching

    Maybe
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    05-11-2022
    Location
    Singapore
    MS-Off Ver
    MS 2019
    Posts
    152

    Re: Help with INDEX MATCH wildcard matching

    @Fluff13

    Tried, can't work. Show error.

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Help with INDEX MATCH wildcard matching

    There's a typo, it should be
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    05-11-2022
    Location
    Singapore
    MS-Off Ver
    MS 2019
    Posts
    152

    Re: Help with INDEX MATCH wildcard matching

    @Fluff13

    Thanks, it works perfect.

  10. #10
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Help with INDEX MATCH wildcard matching

    My pleasure.

+ 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 with Wildcard Not Working
    By JadeOwl in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-28-2022, 11:24 AM
  2. [SOLVED] index match wildcard
    By carrollm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2019, 01:39 AM
  3. [SOLVED] Index and match using wildcard
    By Eustace07 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-09-2016, 01:30 PM
  4. 2 variable index match with wildcard
    By izk630 in forum Excel General
    Replies: 4
    Last Post: 10-26-2015, 02:42 PM
  5. [SOLVED] INDEX - MATCH on two Criteria with wildcard
    By SrDurham in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2015, 09:04 AM
  6. [SOLVED] Index,Offest, Match, Wildcard?
    By fgruhlke in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-18-2014, 11:27 PM
  7. [SOLVED] Wildcard text match using INDEX and MATCH
    By mmayna03 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-12-2012, 03:02 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