+ Reply to Thread
Results 1 to 5 of 5

Using Index Match to return a text value

  1. #1
    Forum Contributor
    Join Date
    11-02-2007
    Posts
    109

    Using Index Match to return a text value

    Hi,

    I have a list that contains figures alongside people's names, which indicates those people have completed a particular task. I want to consolidate the responses into one list to simply show 'Yes' if a person has completed the task on a certain date.

    I have attached an example. The first tab is how I would like the formula to return 'Yes' if there is a figure in the corresponding column on the second 'data' tab. For example on the data tab for Bob there is a figure 3 for 1/3/18. On the first tab I don't want it to return the figure 3 which I could of course do with an index match formula. Instead I want to modify the formula to do an index match however return 'Yes' instead of the figure in the column on the first tab.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Using Index Match to return a text value

    hi there. try this in cell B5:
    =IF(COUNTIFS(Data!$A:$A,$A5,INDEX(Data!$B:$D,,MATCH(B$4,Data!$B$3:$D$3,0)),">0"),"Yes","")

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,834

    Re: Using Index Match to return a text value

    Please Login or Register  to view this content.
    Ben Van Johnson

  4. #4
    Forum Contributor
    Join Date
    11-02-2007
    Posts
    109

    Re: Using Index Match to return a text value

    Awesome thanks so much, works perfectly!

  5. #5
    Forum Contributor
    Join Date
    11-02-2007
    Posts
    109

    Re: Using Index Match to return a text value

    Fantastic thank you, works perfectly!!

+ 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 multiple criteria (text not return)
    By balajisrinath87 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-31-2017, 07:18 AM
  2. [SOLVED] Index / Match - match 3 input values and return the results from the index
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2016, 07:34 PM
  3. Use Index Match With Choose To Return Text Data from different sheets
    By WayOverMyHead in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-30-2016, 10:08 AM
  4. [SOLVED] Combining 3 Formulas: Return all Names that Match Criteria Using Index/Match
    By bchilme in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-29-2014, 09:28 AM
  5. Replies: 3
    Last Post: 06-17-2013, 01:09 PM
  6. Replies: 3
    Last Post: 05-08-2013, 02:10 PM
  7. Trying to use match and index but return a text not numercial answer
    By parrot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-04-2013, 10:44 AM

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