• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Finding a word in a sentence.

kavitha

New Member
Hello All,

I need to find a word/Server name in a sentence, the word would be randomly placed. Can you help me with the formula to find this.

Pasting the sample.

SYYSPDB01 - The free space of logical drive C: is less than 5.0% where i have to find
" SYYSPDB01 " and "SYYSPDB01 " i have list of array of different words.

Have attached a sample file for reference pls help.
 

Attachments

  • Sample.xlsx
    12.5 KB · Views: 7
Hi @kavitha

Welcome to the forum..

Check the attached if below working for you..

=IFERROR(LOOKUP(2,1/ISNUMBER(SEARCH(Sheet2!$A$2:$A$17,Sheet1!AA2)),Sheet2!$A$2:$A$17),"Not From list")
 

Attachments

  • Sample (5).xlsx
    13.5 KB · Views: 3
Back
Top