Return Cell Value if Contains Specific Text

Hi all!

I have a range of text (customer names), similar to below:

ABC Company U.S.
Wildcard Incorporated
XYZ LLC
Worldwide Corporation

I'm looking to find company XYZ and Wildcard within this range. I have a countif formula to count how many times the company is mentioned within the list using the text "XYZ" and "Wildcard". Turns out each company I'm looking for is only listed once. How do I write a formula that returns the entire value of the cell in which I've found "XYZ" and "Wildcard". (It would return "XYZ LLC" and "Wildcard Incorporated".)

Thanks!!

Thanks for the response!

When I try that formula with my table, it's returning #N/A. Do you know why that could be?

Oh got it!

This is what I put (just added another "*" before the text being searched):

=INDEX(A$1:A$4,MATCH("*"&C1&"*",A$1:A$4,0))

I can't get it to work. Using Excel 2013. Is there a better way?

Huh. Found out a network-sagging event corrupted my Excel. Now that it's been reinstalled, the formula works. Many thanks.