+ Reply to Thread
Results 1 to 2 of 2

Match name to a list

  1. #1
    Registered User
    Join Date
    06-26-2018
    Location
    Singapore, Singapore
    MS-Off Ver
    Microsoft Office for Mac 2016
    Posts
    2

    Match name to a list

    I'd like to match names to form responses to check if my students has completed the online quiz form i made.

    Not everyone submitted in the format I wanted (first name only), so when it checks the name, it must be able to check if it is part of a name too.

    What formula should I insert into O2:O9?

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,209

    Re: Match name to a list

    This should work copied down:

    =IF(COUNTIF($A$2:$A$7,N2&"*"),TRUE,FALSE)

    or just this:

    =COUNTIF($A$2:$A$7,N2&"*")>0
    Last edited by AliGW; 01-12-2019 at 02:02 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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