Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for a text string
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for a text string
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 "Dan" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search text string within array | Excel Discussion (Misc queries) | |||
How do a search for a text string using a formula | Excel Discussion (Misc queries) | |||
Text search within a string using formula | Excel Worksheet Functions | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
Newbie: How to search a text string from right | Excel Worksheet Functions |