+ Reply to Thread
Results 1 to 2 of 2

Find / Search Function to to identify if a text string is in a list

  1. #1
    Registered User
    Join Date
    02-13-2018
    Location
    Midlands
    MS-Off Ver
    365 Version 2208
    Posts
    9

    Find / Search Function to to identify if a text string is in a list

    Good afternoon all,

    I am hoping one of you helpful users will be able to help me with the attached.

    Basically i am trying to write a formula with either find or search to identify if a text string in a cell is in a column. i have a list of works activities previously forecast to be completed in the month (in column B) and a list of the actual works activities completed in the month (in column E.) i want the formula in column C to look for the works activity in column B and identify if it is in column E also.

    So the formula in the attached in Cell C5 will look for the works activity in cell B5 in cells E5 to E17.

    Ideally if it could make the item in cell B5 a wildcard, that would be ideal as you will notice in the attached cell B6 "Ferric Dosing +POA's" has been completed in the month (as it is in column E) however in column E this is just identified as "Ferric Dosing". If this is not possible however, it is not the end of the world as i appreciate that will likely make the formula much more complex and i don't want to go down the route of VBA.

    If anyone could have a look and come up with a solution, it would be greatly appreciated!

    Many kind regards
    Andrew
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Find / Search Function to to identify if a text string is in a list

    You could use this formula in C5:

    =IF(COUNTIF($E$5:$E$17,"*"&LEFT(B5,22)&"*"),"Yes","No")

    then copy down.

    Hope this helps.

    Pete

+ 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. search text string using comma delimitated list
    By ian2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2017, 10:35 PM
  2. [SOLVED] Search and Find - To extract some text from a string of text
    By Badvgood in forum Excel General
    Replies: 4
    Last Post: 11-01-2016, 01:04 PM
  3. FIND/SEARCH plus MID formula for Text String Problem
    By Rapper2nite in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2013, 01:53 PM
  4. Update Combo/List Box based on Text box search string
    By megha_gharote in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2013, 06:16 AM
  5. [SOLVED] VBA to Search a Text String, Find a Value listed in another column and replace the text
    By Jschrod303 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2012, 08:56 PM
  6. Search for occurences of text string from a list
    By howardphillis in forum Excel General
    Replies: 13
    Last Post: 05-25-2012, 08:37 AM
  7. [SOLVED] Userform Find (VLOOKUP) function search string problem
    By TalResha in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2011, 04:14 AM

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