Rowland Hamilton
Active Member
- Joined
- Nov 13, 2009
- Messages
- 250
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:
so that the "*Starbucks*" is populated by a cell reference? I couldn't get Indirect to work:
where C3=company name
Thank you - Rowland
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:
Code:
COUNTIF('ListB'!$B:$B,"*Starbucks*")
Code:
COUNTIF('ListB'!$B:$B,Indirect(""*"&C3"*"")
Thank you - Rowland