Search/Find wildcard, Indirect Match

[Rowland Hamilton]

Folks:

I want to determine which companies in ListA are mentioned in ListB.
Each cell in column B of ListB has the company name embedded in a phrase.

How can I modify this formula:

COUNTIF('ListB'!$B:$B,"*Starbucks*")

so that the "*Starbucks*" is populated by a cell reference? I couldn't get Indirect to work:

COUNTIF('ListB'!$B:$B,Indirect(""*"&C3"*"")

where C3=company name

Thank you - Rowland

 

[VoG]

Try

=COUNTIF('ListB'!$B:$B,"*"&C3&"*")