+ Reply to Thread
Results 1 to 4 of 4

Using Match/Index/Search Functions

Hybrid View

fl9805 Using Match/Index/Search... 08-10-2014, 07:26 AM
Glenn Kennedy Re: Using Match/Index/Search... 08-10-2014, 07:57 AM
fl9805 Re: Using Match/Index/Search... 08-10-2014, 08:07 AM
Glenn Kennedy Re: Using Match/Index/Search... 08-10-2014, 09:30 AM
  1. #1
    Registered User
    Join Date
    01-06-2009
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2013
    Posts
    11

    Post Using Match/Index/Search Functions

    Hello everyone,

    This thread is a follow up to another thread where I got several great answers to my issue.
    http://www.excelforum.com/excel-gene...functions.html

    Some of the solutions offered were:
    Array formula
    =IFERROR(INDEX($F$4:$F$15,MIN(IF(ISNUMBER(SEARCH($E$4:$E$15,A2)),ROW($E$4:$E$15)-ROW($E$4)+1,99))),".")
    Non-array formula
    =IFERROR(INDEX($F$4:$F$15,MATCH(TRUE,INDEX((COUNTIF($A2,"*"&$E$4:$E$15&"*")<>0),0),0)),".")

    I came up with several additional issues and was wondering if anyone could please help again (e.g., text but no dates).
    I have attached the file which shows the current output with one of the solutions suggested earlier. I added the desired outcome.

    Thanks again for your invaluable support!
    Attached Files Attached Files
    Last edited by fl9805; 08-10-2014 at 07:34 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Using Match/Index/Search Functions

    Paste this into B2 and copy down. Looks OK to me!
    Formula: copy to clipboard
    =IF(A2="",0,IF(ISNUMBER(SEARCH("/??/",A2)),IFERROR(INDEX($E$4:$E$15,MATCH(TRUE,INDEX((COUNTIF($A2,"*"&$D$4:$D$15&"*")<>0),0),0)),"."),"."))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    01-06-2009
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Using Match/Index/Search Functions

    World class! Thanks so much Glenn

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Using Match/Index/Search Functions

    You're welcome & thanks to you, too!

+ 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] Using Search and Lookup/Match/Index Functions
    By fl9805 in forum Excel General
    Replies: 14
    Last Post: 08-06-2014, 10:47 AM
  2. [SOLVED] Working INDEX MATCH with SEARCH, but I need to add another MATCH to the formula!
    By DaveBre in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-11-2014, 01:03 AM
  3. Index and Match functions
    By bmark in forum Excel General
    Replies: 3
    Last Post: 05-01-2012, 06:02 PM
  4. Using Index & Match Functions
    By DanSherwood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-22-2008, 09:48 PM
  5. [SOLVED] Index and Match Functions
    By Damien in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-29-2006, 05:20 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