Find exact string in a range of cells

[cvansickle]

Hello All..

I have an excel report that gives me a "Reason" in one of the cells. However the reason has some information at the end of the string.

Example in Cell: UNDELIVERED - Ran Out Of Time (Ran Out Of Time) on 18:34 EST12/02/2020

What I need to do is find all the "UNDELIVERED - Ran Out Of Time" in a certain range, but not the rest of the wording in the string.

Is there a was way to do a vlookup (or anything else) that will find an exact match of words in a string and then give me the result.

Hopefully this make sense.

Thanks in advance

ChadnVegas

[Glenn Kennedy]

And what is your expected result? Easier if you read the yellow banner (top of page) and post a small sample showing what you have and what you want.

[Pete_UK]

Both VLOOKUP and MATCH (as part of an INDEX/MATCH combination), as well as COUNTIF etc., can use wildcard characters. I'm not sure what you are trying to do, though, when you say that you want to "find" all the cells which contain that text.

Perhaps you should attach a sample workbook and show in there (manually) what you want to achieve. The yellow banner at the top of the screen gives details on how to do this.

Hope this helps.

Pete

[cvansickle]

I tried to attach an example..

Column C is the information I receive from the report

Column F is the string I am looking for

Column G is the result.

This is on a VLOOKUP formula. There may be an easier way..

[Glenn Kennedy]

?? In D2:

=IFERROR(LOOKUP(1000,SEARCH($F$2:$F$8,C2),$G$2:$G$8),"")

[cvansickle]

Perfect Glenn..

Thank you sooo much..

You guys are amazing!

Chad

[Glenn Kennedy]

LoL. No... just done that before!!

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.