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!!