Search for a text string

D

Dan

Hi,

I have 2 lists of companies.

I want to search for whether the companies on list 1 are on list 2.

For example, "Chrysler Holding LLC" on list 1, "Chrysler Holding" on list 2.
How can I search "Chrysler" from list 1 is on list 2 as well.

Thanks.
 
S

ShaneDevenshire

Hi,

VLOOKUP supports wild cards so you can use something like this

=VLOOKUP(B5&"*",F4:G11,2,FALSE)

where B5 contains Chrysler Holding and F4:F11 contains Chrysler Holding or
Chrysler Holding LLC. Or you can just check to see if it is in the first
column with

=VLOOKUP(B5&"*",F4:F11,1,FALSE)

COUNTIF also supports wildcards, so

=COUNTIF(F4:F10,B5&"*")

However if you really look "Chrysler Holding LLC" up in a column which
contains only Chrysler Holding you won't find it.

If this helps, please click the Yes button.

Thanks,
Shane Devenshire
 
Top